cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GarethWoodhouse Resolver I
Resolver I

Sorting a Matrix by 2 values

I have a matrix that resembles the following:

 

Year, Country, Value

2019 UK          100

2019 France    200

2019 Germany 300

2020 UK           200

2020 France     100

2020 Germany 300

 

And I want it ordered by Year, Value

2019   Germany   300

2019   France       200

2019   UK             100

2020   Germany    300

2020   UK              200

2020   France        100

 

Currently I have the option to sort by Year only or Value only. 

Is there a way to replicate the SQL Group by Year, Value?

 

Thanks.  

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV
Super User IV

Re: Sorting a Matrix by 2 values

Refer

https://community.powerbi.com/t5/Desktop/Sorting-by-multiple-columns/td-p/535690

 





Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP,
HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Super User! Linkedin


View solution in original post

2 REPLIES 2
Super User IV
Super User IV

Re: Sorting a Matrix by 2 values

Refer

https://community.powerbi.com/t5/Desktop/Sorting-by-multiple-columns/td-p/535690

 





Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP,
HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Super User! Linkedin


View solution in original post

GarethWoodhouse Resolver I
Resolver I

Re: Sorting a Matrix by 2 values

I couldn't get the measure to work but the suggestion regarding the index column got me to where I needed to be by hiding the index column in my matrix and sorting the table by the index column. Thanks for the pointer to the thread.

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors