Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
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)
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! 🙂
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
9 |
User | Count |
---|---|
28 | |
23 | |
12 | |
11 | |
10 |