Power BI – Date Slicer with Default Selection
Magic of the new Power BI Button Slicer: the current calendar month is always selected by default. In the video, I change the system date, … Read More
Category: Tricks and Workarounds
Pseudo Row Level Security (RLS) for Publish to Web Power BI Reports
This post is an update for What is new? One of the users has found a critical issue in the old version of the report: … Read More
Update Power BI Dataset (Semantic Model) More Than 8 Times a Day (Without Premium)
It’s not possible to refresh a dataset more than 8 times a day (shared capacity). However, it is possible to have a report with data … Read More
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
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