cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sanju_g
New Member

Column header sorting in multi dimensional Matrix

I am using Multidimensional Matrix where I have Fiscal Month as 1st Level and for each Fiscal Month I have Actual and Budget numbers. I am using excel data for this report.

 

In second level, by default, the header are displaying as Actual (First) and Budget (Second), I want to display Budget (First) and then Actual (Second). Is there any way to do the column sorting. There is some option of Column sorting in Modelling Menu option, but that is disabled.

2 REPLIES 2
v-frfei-msft
Community Support
Community Support

Hi @sanju_g,

 

Could you please share your sample data and excepted result to me ? So that I can help with it.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.




 

Hello,

 

Below is by data format. If you see row 2 below where it says Actual & Budget for each Fiscal Month. I want this to be Budget and Actual, instead of the way it displayed.

 

Fiscal Period201801201802201803201804
Initiative IdActualBudgetActualBudgetActualBudgetActualBudget
C000213112333311245541333112462567331124  
D00555-22264794 -7188687     
D00555-3        
D00440        
D00646        

 

Thanks & Regards,

Sanjeev

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.