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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
moatazezat
Helper I
Helper I

Sorting measure by the largest percentage in last year

Dears, 

I would like to Sort by the largest percentage in last year "2023". 

Thanks 

 

 

Sort descending by last Year 2023.JPG

2 REPLIES 2
Greg_Deckler
Super User
Super User

@moatazezat I don't believe that sorting is advanced enough to pull off what you are trying to achieve. The only sorting options you have available are accessed via the ellipses (...) in the upper right of your visual in your picture. I could be incorrect but I believe that the only sorting options you are going to have available to you are to sort by the Axis (Y-Axis) or to sort by the your value in the X-axis (Sales % Region). Sorting is simply not advanced enough to filter by the value in the X-axis for a particular legend value.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
moatazezat
Helper I
Helper I

any reply, please.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.