Power BI Theme JSON tricks
I love Power BI community for the inspiration it gives. Today after reading this LinkedIn post by Jan Schroeven I realized that if Power BI … Read More
Category: Tricks and Workarounds
Better Treemap with meaningful colors and scaling
How to show almost 200 countries data on a treemap visual? For this experiment I took international trade statistics (merchandise exports by product group, annual) … Read More
How to Breed a Unicorn? Dumbbell Chart in Power BI
It started with @shan_gsd‘s tweet about Year 2022 Week 33 of the Workout Wednesday and @CJMajka‘s reply “A dumbbell chart in #PowerBI?! That is kind … Read More
Backup/restore all calculation groups (workaround required for some visuals)
I needed to add a gantt chart into a report. I tried multiple visuals, but they didn’t work because they all require at least one … Read More
Power BI: HTML formatted titles
I hope Microsoft will allow HTML or BBCode tags in titles [ideas.powerbi.com]. It will be a game changer. In many cases a formatted title replaces … 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
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
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
Simple authorization based on a slicer and DAX measures
I decided to start a blog about Power BI. And while my web site is not complete yet (need some design changes, SSL certificate has … Read More