See data and reporting from every angle

Microsoft Fabric, Power BI and the plumbing underneath. Written from real projects, with the templates and cheatsheets to go with them.

Power Query vs. Power BI Rest API

The Power BI Service hides data that is not visible at first peek but can help us control the Service and properly check whether there are any irre...

Multi-Color Gradient with DAX in Power BI

There are more than just many visual elements and their use in Power BI.Many of them are natively, and you have to create them yourself. One such s...

Conditional Formatting with Calculation Groups

The second part of this series is focused on conditional formatting and calculation groups. Because calculation groups are a fascinating component ...

Conditional Formatting based on Field Parameters

Conditional formatting. It can sometimes seem like magic, what a few colors that appear at the right moment can do. Of course, the same applies to ...

Hierarchies with dynamic levels in Matrix by Field Parameters

Hierarchies are the bread and butter of Power BI. We've probably all come across that the Matrix within the hierarchy often displays empty values ​...

Rebinding Power BI Reports to Different Dataset

Duplicate Power BI Dataset, from which colleagues have already managed to make their reports? Doesn't that sound scary? Personally yes!