M365 Show -  Microsoft 365 Digital Workplace Daily

M365 Show - Microsoft 365 Digital Workplace Daily

Microsoft Data Pulse: Power BI, Fabric, Purview

Making Measures Act as Columns in Power BI for Dynamic Reporting

Mirko Peters - M365 Specialist's avatar
Mirko Peters - M365 Specialist
Jul 11, 2025
∙ Paid

You often want to build a Power BI matrix that goes beyond basic totals. Maybe you need columns for each month, the quarter’s total, last year’s numbers, or even growth rates. When you try to use measures as columns, you quickly see that standard visuals do not support this level of flexibility. If you want to use measures for custom columns and dynamic…

This post is for paid subscribers

Already a paid subscriber? Sign in
© 2025 Mirko Peters
Publisher Privacy ∙ Publisher Terms
Substack
Privacy ∙ Terms ∙ Collection notice
Start your SubstackGet the app
Substack is the home for great culture