Top 5 and everything else other

Question

&nbsp;My pie chart shows the percentage of each job title based on count. I only want to show the top 5 though, and I want everything else to be show in something called "Other". I want this to be dynamic, meaning the top 5 could change if I uploaded new data.

eric_zhang · Accepted Answer

pkumar
AFAIK, it is not supported in a visual setting, but you can create a calculated column as a workaround.
&nbsp;
category_&nbsp;=IF&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;CONTAINS&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TOPN&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SUMMARIZE&nbsp;(&nbsp;'table',&nbsp;'table'[category],&nbsp;"cnt",&nbsp;COUNTA&nbsp;(&nbsp;'table'[category]&nbsp;)&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[cnt],&nbsp;DESC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'table'[category],&nbsp;'table'[category]&nbsp;&nbsp;&nbsp;&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;'table'[category],&nbsp;&nbsp;&nbsp;&nbsp;"other")

Forum Discussion

Top 5 and everything else other

2 Replies

Related content

Average everything else

Show everything else

Translate IF, ELSE IF, ELSE in DAX langage

if then else

Mark Date Table after everything