cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
robertbu
Frequent Visitor

How do you display your top 2 vendors by a certain measure using ranking

Hi @JarroVGIT ,

 

   You helped here with the ranking measure, which I hoped to use for filtering a visualization.

   It would be interesting for me to see how you displayed the values 

   How would you go about creating a visual with two bars showing us the number of orders by vendor for the top 2 vendors basically?

 

   I wanted to use the ranking measure so I can filter the top x vendors by number of orders, or amount, etc.

   As I quickly learned it seems I cannot use measures to filter visuals, however the added complexity I understand now is that the in-memory calculation doesn't show the value of the ranking either in a visualisation. (this comes with a natural question: what is a good use of the ranking if we can't display it - is it used just for pre-processing to calculate other measures? ) Could I copy it's values in a column so I can then use it for filtering?

 

Cheers,

Robert

 

   

1 ACCEPTED SOLUTION

Accepted Solutions
Super User I
Super User I

Re: How do you display your top 2 vendors by a certain measure using ranking

You can use the Ranking measure in a visual filter like this:

image.pngNote the filter on Ranking

I dragged the measure to the visual filter myself and set it to (for everything lower than 3 (so 1 and 2 haha)). This shows the 2 vendors in a diagram 🙂 This measure is not aware of the filtered context (it creates its own context by using the ALL statement in the first variable). Does this help?

 

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

 


Did I answer your question? Mark my post as a solution!
Kudo's are appreciated and considered a motivation.

Proud to be a Datanaut!

View solution in original post

2 REPLIES 2
Super User I
Super User I

Re: How do you display your top 2 vendors by a certain measure using ranking

You can use the Ranking measure in a visual filter like this:

image.pngNote the filter on Ranking

I dragged the measure to the visual filter myself and set it to (for everything lower than 3 (so 1 and 2 haha)). This shows the 2 vendors in a diagram 🙂 This measure is not aware of the filtered context (it creates its own context by using the ALL statement in the first variable). Does this help?

 

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

 


Did I answer your question? Mark my post as a solution!
Kudo's are appreciated and considered a motivation.

Proud to be a Datanaut!

View solution in original post

robertbu
Frequent Visitor

Re: How do you display your top 2 vendors by a certain measure using ranking

Makes sense, so you can't use it in slicers, but works well in filters.

All good, this is the way forwards then, thank you again!


Robert

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.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors