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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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.