Solved: Show Top N Customer and Remainning Customer as "Ot...

urspalani · ‎09-04-2017

Hi Folks,

Is there any way to use Top N filter to Show my Top N and remainning all to Group as "Others" ?

Thanks,

v-qiuyu-msft · ‎09-06-2017

Hi @urspalani,

You can follow these two articles:

Show Top N and Rest in Power BI

POWER BI – RANKING WITH 'OTHER' GROUP

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-qiuyu-msft · ‎09-06-2017

Hi @urspalani,

You can follow these two articles:

Show Top N and Rest in Power BI

POWER BI – RANKING WITH 'OTHER' GROUP

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Greg_Deckler · ‎09-05-2017

Hmm, I can't think of a way to do that but figured I'd add myself to the thread in case someone can answer this.

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Show Top N Customer and Remainning Customer as "Others"

Helpful resources

Fabric certifications survey

Fabric Community Update - April 2024