cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## How to sort a matrix based on the column of your choice OR based on an external value?

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.

The matrix is sorted by the last column on 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?

Camille

8 REPLIES 8
Community Support

hi  @Anonymous

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.

Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User

@Anonymous , In Matrix as of now you can sort the columns on Row Grand totals if you use columns. That you can change using three dots.

Anonymous
Not applicable

@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).

Super User
Anonymous
Not applicable

@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!

Community Champion

Here is an Example

Water Target is a measure

Regards
Amine Jerbi

and you can follow me on

Community Champion

Hi @Anonymous

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

https://app.powerbi.com/view?r=eyJrIjoiMjc2N2ZkZmYtMTNjYi00N2Q0LWE4MmUtYjhiY2E4NTQxZGM1IiwidCI6IjgzNTU5ODFiLTJlYTYtNDdjZi04ZjJiLTc3MTY3N2FmZjMyZCJ9

Regards

Regards
Amine Jerbi

and you can follow me on

Anonymous
Not applicable

@aj1973  Thank you for your reply. I know how to sort a column but how do I sort a measure?

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors