Forum Discussion
Ranking and Create Group Issue
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.
2 Replies
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! 🙂
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)
