Hi, I need to create a Pie chart based on Dimension and measure(count of column). I have a table like thisIDName6hat7kitty1john3john2kate4kate5kateI need like below to be in Pie chartNameCount rowKate3John2Other2Total7Later 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?

Created as per the below link. https://community.powerbi.com/t5/Desktop/TOP-10-Pie-Chart/m-p/462158

Forum Discussion

Helper I

4 years ago

Solved

Hi,

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

I have a table like this

I need like below to be in Pie chart

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?