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

Don'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.

Reply
rob2
Frequent Visitor

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 2
harshnathani
Community Champion
Community Champion

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
Resident Rockstar
Resident Rockstar

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.