Ranking and Create Group Issue

[rob2]

I have a measure that ranks competitors by the number of scrapes.  I am then using a disconnected table to filter only the top 5 competitors with the most scrapes.  The top 5 competitors ranking is dynamic because the user can select the dates and products.

My issues is that we I use a line chart and try to create a Group on those top 5 competitors it automatically brings back all of the competitors.  How can I Group only the 5 competitors?  

Thanks.

[harshnathani]

Hi @rob2 ,

See if this article helps you

https://www.sqlbi.com/articles/showing-the-top-5-products-and-others-row/

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[JarroVGIT]

Can you please post a pbix file without confidential information? Then we can have a look at what you have tried already and how your data model looks like 🙂

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! 🙂