Top 10 and Others

[tulasi_pbi1988]

Hi,

I need to create a Pie chart based on Dimension and measure(count of column).

I have a table like this

ID	Name
6	hat
7	kitty
1	john
3	john
2	kate
4	kate
5	kate

I need like below to be in Pie chart

Name	Count row
Kate	3
John	2
Other	2
Total	7

Later I need to associate this table with another table based on the ID column for filtering.

Could you let me know if any solution having?

[tulasi_pbi1988 · Accepted solution]

Created as per the below link.

https://community.powerbi.com/t5/Desktop/TOP-10-Pie-Chart/m-p/462158

[tulasi_pbi1988]

@jdbuchanan71 

I don't have the Amount column and I need to count the Name column only.

[jdbuchanan71]

@tulasi_pbi1988 

You can find a solution in this thread.

https://community.powerbi.com/t5/Desktop/Pie-Chart-Top-5-Rest-named-Other/td-p/737504