Skip to main content
cancel
Showing results for 
Search instead 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

Reply
marcl1
Helper II
Helper II

How to sort a "complex" matrix by the columns?

Dear gents,

 

for some specific reasons I have in the service a matrix with columns and values as the one below.

Sorting on the totals by each value is no problem.

Is it possible to sort in this configuration, as an example by Finland decreasing sales?

Tried selecting specifically a column, looking in the ellipses to sort, even clicking on Shift or Ctrl, but apparently nothing provides what I want/need... It always sort based on Totals...

Has someone a tip?

 

 

2023-11-06_08-20-30.jpg

6 REPLIES 6
v-tangjie-msft
Community Support
Community Support

Hi @marcl1 ,

 

According to your description, here are my steps you can follow as a solution.

(1) This is my test data.  

vtangjiemsft_1-1699430231492.png

(2) Click "transform data" to go to the power query, sort the [sales] column in descending order, then add the index column, and finally click "close and apply".

vtangjiemsft_0-1699430210977.png

(3) Select the [total sales] column to sort by the index column.

vtangjiemsft_2-1699430348013.png

You can create indexed columns as you see fit and then use sort by column.

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

Thx for your proposal, but it requires a static change in the query editor (my fact table behind has 150 million lines). Furthermore, the Finland case was only an example and even sorting by Country is not so obvious when it is a field of a Dimension Table and the sortiment can be done on so many fields...

Hi @marcl1 ,

 

Unfortunately, as @Brunner_BI  said, this is not possible.

If you would like to suggest  feature improvements, you may vote the idea and comment here to improve this feature. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

Thx for the answer, there is already such an idea opened since 2017... so my hopes are quite limited!

marcl1
Helper II
Helper II

This is the answer that I feared 😭

Nevertheless thank you 

Brunner_BI
Super User
Super User

As far as I know it is just not possible and we can only sort e.g. also based on two columns in a normal table visual...

------------------------------------
Brunner BI focusing on Microsoft Power BI development and consulting
Developers of external tool "Measure Killer"
My blog

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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