cancel
Showing results for 
Search instead for 
Did you mean: 
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

View solution in original post

@Sean

 

Thanks a lot! Tottally fulfills my need.

 

Best regards,

Germano Basler

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors