Solved: TOP N and extendable rest

CarlsBerg999 · ‎10-13-2020

Hi,

I want to create a report where it says the top 10 of my customers based on sales and the rest in an "extendable Others". Therefore the 11th customer would be called "Others" and the value would be the sum of all other customers. If i click the plus sign, it would extend the table to show what the Others -category consists of.

Is it possible to do this in Power BI? Thank you in advance!

amitchandak · ‎10-13-2020

@CarlsBerg999 , refer if these can help

TOp N with Others
https://www.youtube.com/watch?v=UAnylK9bm1I
https://blog.gbrueckl.at/2019/05/power-bi-dynamic-topn-others-with-drill-down/

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

View solution in original post

amitchandak · ‎10-13-2020

@CarlsBerg999 , refer if these can help

TOp N with Others
https://www.youtube.com/watch?v=UAnylK9bm1I
https://blog.gbrueckl.at/2019/05/power-bi-dynamic-topn-others-with-drill-down/

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

TOP N and extendable rest

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly