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.

OFFSET and its usage with Calculation Groups

December update brings officially new DAX functions into PowerBI. I was playing a bit with one of them... with OFFSET and especially in cooperation...

Restrict Power BI Integration Button in Microsoft Lists

Power BI and integration to Sharepoint Lists have been with us for some time. Some can turn them on, or only specific groups of users can access th...

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 ...