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
sjc4062
Frequent Visitor

Ranking different measures for dynamic display

Hello,

 

I am looking to be able to create a ranking system for a group measures i currently have. 

 

End goal: Be able to apply the ranking to a  visuals so it will show the number 1 ranked measure at all times.

 

Details:  I have several measures created to measure % changes of various items. I am attempting to rank them based on largest % change. The measures are all from the same data soruce currently but potentially adding addtional in the future.

 

Example:  I have 40,000 rows of sales data. I am attempting to identify the thing that is most important and display that but not have to manually make that descion. 

Measures:

  • 10% Change in customer retention 
  • -8%  cash purchases
  • +14% international purchases

So i would want my display card to show only the +14 % international purchases. 

Apolgies if this was covered somewhere but i wasn't able to find anything.

 

                  

1 REPLY 1
CheenuSing
Community Champion
Community Champion

Hi @sjc4062

 

It would be good if you can follow the link to provide more details

 

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

 

Cheers

 

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

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