Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
You can find a solution in this thread.
https://community.powerbi.com/t5/Desktop/Pie-Chart-Top-5-Rest-named-Other/td-p/737504