Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi,
Currently, in my dataset the Revenue Band is in column section and Current Year, Prior Year and the Delta columns are defined as measures. When I create a matrix view the default view is created as follow. Is there any way that I can change the hiearchy in the column to group by the measures first then break down by the Revenue band as in the second screenshot in below wihtout changing the dataset design?
@encamped1 , You need a calculation group for that
Refer examples and formats- Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0