Analyzing Data with Power BI and Power Pivot for Excel by Alberto Ferrari, Marco Russo
While you can import one table from an Excel file into Power BI and start adding fields into a visual, in most cases your data … Read More
Collect, Combine, and Transform Data Using Power Query in Excel and Power BI by Gil Raviv
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
Introduction, a visual with fully disabled interactivity for cover page. I’m starting a series of posts based on “Storytelling with data. Let’s Practice.” book by … Read More