Collect, Combine, and Transform Data Using Power Query in Excel and Power BI
I usually don’t read books with step by step instruction like “click File, then click Open”. I start working with a new tool right away … Read More
A power BI report that displays its own metadata, including refresh history
A crazy Power BI idea is in my head. It rather doesn’t make much practical sense, but such crazy ideas sometimes lead to useful solutions for the … Read More
PowerShell script to publish Power BI reports into multiple tenants
I’m working with multiple Power BI tenants, workspaces and reports. It’s a pain to log out (I’m always logged in with an account for previous report), copy … Read More
Line and stacked column chart with outliers
In this post I’ll show how to handle a time series of data with outliers (extremely high values). For example, number of new COVID-19 deaths … Read More
Stacked column chart conditional formatting (COVID-19 report)
I have updated my COVID-19 report today. New chart design: Old chart design: Old version of the chart worked, but it wasn’t perfect because of … Read More
Who is a data storyteller? A composer or a musician?
I’ve been mentioned and a link to my blog has been shared by SWD (thank you!). The post itself and a few comments under the … Read More
Storytelling with data in Power BI: part 3
Storytelling with data in Power BIStorytelling with data in Power BI: part 2 So far I have created 11 pages report (+ title page) with … Read More
Storytelling with data in Power BI: part 2
Since my first post about storytelling in Power BI I’ve created first 8 pages of the report : In some cases you may want to … Read More
Storytelling with data in Power BI: part 1
I’m starting a series of posts based on “Storytelling with data. Let’s Practice.” book by Cole Nussbaumer Knaflic. The visuals that illustrate exercise solutions in … Read More
Power BI: toggle button to switch between linear and log scale
There are 2 ways to switch between linear and log scale: we can use bookmarks to switch between 2 different charts we can use DAX … Read More