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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Sorting Values in Matrix with multiple columns & values

Hello,

 

It seemed quite trivial but I do not manage to sort ascending/descending values in my matrix's columns

I have several financial KPIs, for each I have actual and budget values. I created a matrix as follows:

 

image.png

But I can't sort the values ascending/descending by just clicking either Actuals or Budget in the KPI I want

image.png

 

But if I take out "Financial Account" from columns, it works (but the values are obviously meaningless as it sums up several different KPI

image.png

Anything I am missing ? it seems to be a very simple thing...

 

Otherwise I though of creating a measure for each combination:

- Contract Margin Actuals

- Contract Margin Budget

- Sales Actuals

- Sales Budget

- ...

 

And put them in "Values" field in the Matrix, so as I can sort individually for each measure...

 

Any hint?

 

Thank you very much for your help,

 

TB

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , Multi-column sorting is not there for matrix yet.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.