Hi, fellow Power BI geeks!
I'm having trouble with sorting a matrix I am building.
I've made a matrix which is linked to a slicer in my page: you can select in the slicer which columns are shown in the matrix.
It's pretty cool and works (not styled yet please don't judge by the looks =p ).
The problem is that the matrix is always sorted by the column that's all the way to the right.
Does someone know how to sort a matrix by a value of your choice?
Either by a specific column or a field that is not present in the matrix?
Thanks in advance!
To my knowledge, matrix visual could only sort by total value for a measure. It couldn't sort by a custom sub-column for now.
@amitchandak Yes, this I know 😃 But grand totals are not useful in this case because each column contains a different information which does not make sense summed up with the others. I wanted to give my users the possibility to sort the matrix by whichever column they want (just like they can in a regular table).
@Anonymous , If you are looking for what is given in this Idea.
Vote for that.
@aj1973 Yes, I already know. But in my matrix the columns are determined by a column in my model. All the values then result from a single measure. Which means I cannot use the "Sort by" option in "..."
@amitchandak Thanks! I'm having trouble voting though... It's requiring a captcha which is not displayed... EDIT: Nevermind, it's displayed now. I voted!
You might need to sort all you column and measures in your Tables before using them into your Matrix.
Enjoy My Report on Covid-19
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.