What if you want to create a highly customised table visualization in Power BI, one that shows product sales across April, May, and June… followed by the quarter total, then the past 3 months, then last year’s quarter, and finally the growth over last year? You can build something like this easily in Excel, but how do you do it in Power BI?
In this blog, I’ll show you how to use calculation groups to build such a visual. You’ll learn how to:
– Use measures as columns
– Show the past 3 months’ data
– Pull last year’s quarter total
– Calculate % growth over last year
– Build a fields parameter to make your visuals dynamic
– Apply dynamic formatting using SELECTEDMEASURE() and FORMAT_STRING
This is a custom table layout that goes way beyond what Power BI normally allows. By the end, your matrix visual will be fully dynamic, clean, and insanely powerful.
