Forum Discussion
Top10+others
Hello,
I'm wondering if is possible to show the the top 10 values and rest as Others in a donut chart.
i have the Id col..I need to show top10 of count of Id col and rest count under Others in a pie chart. how to do that?
Anonymous
Add an index column first and create a calculate column:ID Column = IF([Index]<=10,[ID],"others")Then put the column in the legend and values. I have this in a donut chart. should be the same if you want a pie chart.Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
2 Replies
- mahoneypat
Microsoft Employee
You can use the technique described in this article - Filtering the top products alongside the other products in Power BI - SQLBI
or
Even easier, use the technique shown in this video at about the 1 hr mark.
(17) Charticulator: Now a Power BI Custom Visual! (with Daniel Marsh-Patrick) - YouTube
Pat
Anonymous
Add an index column first and create a calculate column:ID Column = IF([Index]<=10,[ID],"others")Then put the column in the legend and values. I have this in a donut chart. should be the same if you want a pie chart.Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
