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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
robstewart89
Advocate IV
Advocate IV

Sort by Column in Matrix Visual - not by Row or by Value

Hi, 

 

Thought this would be an easy one but can't find another post on this or a solution anywhere. 

 

I have a Matrix Visual with Product on the rows, Year on the Columns and Sales in Values. See below:

 

 

It is sorted currently on Product ascending and I can change it to sort by Total Sales, which is standard.

 

However, there is no way I can see to sort by 2015, or 2016 and so on. So 2015 would be Product 1, Product 4, Product 2 and Product 3.

 

Is there a reason why this basic functionality isn't there, that I'm missing?

 

I can create measures that calculate the Sales in each of the years and use this as a Table visual but this isn't recommended with a larger data model.

 

Is there maybe even another custom visual out there that can do this?

 

Thanks,

Rob

 

 

 

 

1 ACCEPTED SOLUTION

Hi @robstewart89,

 

Currently it is not possible to meet your requirement in Power BI. There is an idea about that, you can vote it up.

 

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

 

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.

View solution in original post

7 REPLIES 7
rjhartop
Helper II
Helper II

Hi, this blog post should provide a solution:

 

https://affinityworks.co.uk/power-bi-matrix-column-sort-sorted/

Alina_Fisher
Frequent Visitor

Hi, this solution worked for me! It allows sorting using RANKX function

 

https://alintelligence.tech/sort-matrix-by-selected-columns-with-rankx/

Anonymous
Not applicable

This worked for my situation...

 

In the upper rght hand corner of the Matrix vistal there an an icon for More options.

1. Click on the . . .

2. Select Sort by

3. Chose the column you want to sort by.

 

I hope this works for you.

v-frfei-msft
Community Support
Community Support

Hi @robstewart89,

 

I have vote the idea. Could you please mark the answer as a solution to close the case please? Thanks in advance.

 

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.
CR
Resolver II
Resolver II

Hi @robstewart89

 

I don't know any visual such a matrix capable to do it.

I don't know if it will be suitable for you but I got same tables displaying each month for a lot of references (products) and, when I need to focus on one period, I add a slicer to select it, then I sort on Total.

 

1.png

For me it is more tha a workaround because I really need to display only on part of the matrix.

 

Regards,

CR

 

Hi @robstewart89,

 

Currently it is not possible to meet your requirement in Power BI. There is an idea about that, you can vote it up.

 

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

 

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.

Thanks @CR and @v-frfei-msft

 

Only 98 votes, needs more! 🙂

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors