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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
germanobasler
Helper I
Helper I

Present First (like Top10 or Top20 ) biggest suppliers out of hundreds in a database

Dear folks, good morning.

 

I recently bumped to a small issue that I am sure there is a way to workaround in Power BI.

 

As I work with a database of hundreds of suppliers, I tried to put on a graph ordering them by amount of spent. Turns out I don´t want to see lots of them in one graph (either a bar or line graph), rather I´d like only the Top5 or Top10 to appear. The "Treemap" graph I think is not possible, as each of the squares are a % of the total, so...

 

Setting the column "width" seems like a total messed unprecise way...

 

Thanks a lot for your valuable advice!

Regards,

Germano Basler

chart top10.JPG

 

 

 

 

 

1 ACCEPTED SOLUTION
Sean
Community Champion
Community Champion

@germanobasler

The easiest way to do this without writing any RANKX or TOPN Measures would be to use the Top N filter introduced in the October 2016 Update. Find out how to use it here...

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-october-feature-summary/preview/#topN

If you still have any questions post back here Smiley Happy

View solution in original post

2 REPLIES 2
Sean
Community Champion
Community Champion

@germanobasler

The easiest way to do this without writing any RANKX or TOPN Measures would be to use the Top N filter introduced in the October 2016 Update. Find out how to use it here...

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-october-feature-summary/preview/#topN

If you still have any questions post back here Smiley Happy

@Sean

 

Thanks a lot! Tottally fulfills my need.

 

Best regards,

Germano Basler

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.