Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
encamped1
Frequent Visitor

Reordering the Columns in Matrix

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?

 

Screenshot 2023-04-18 at 1.42.49 PM.png

1 REPLY 1
amitchandak
Super User
Super User

@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 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

Top Kudoed Authors