cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rdumont
Frequent Visitor

sort power bi matrix by measure

how can i sort the following matrix by a measure? I have dates as columns and 4 measures, when i try to sort by the Growth vs Prev measure it does not work. If i remove the date column it sorts fine...

Capture.PNG

4 REPLIES 4
jdbuchanan71
Super User II
Super User II

Hello @rdumont ,

When you have a table like yours with a category field (date in your case) on the columns the sorting takes place on the total, not one of the individual columns (July 7th).  If you add the column subtotals in you should see how the sorting is applied, to the total [Growth vs. Prev].

thank you @jdbuchanan71 that explains what it is doing, by extension does that mean it cannot be done at the column level?

Assuming it cannot does this request address it:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13808061-matrix-sort-columns-by-v...

 

Many thanks!

The suggestion you linked looks like they are talking about nested layers in the columns rather then being able to sort a matrix by a sub-section so I don't think it would fix your problem.

rdumont
Frequent Visitor

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.