Forum Discussion
Solved
Grouping Values in Pie Chart
Hello, I have a pie chart that has a legend of employee names and counts the amount of shifts they have had in the last 14 days. I am looking to count and group the results into three categ...
Hi Dave2534 ,
I created some data:
Here are the steps you can follow：
1. Create calculated column.
Switch = SWITCH( TRUE(), 'Table'[Count]>=0&&'Table'[Count]<=9,"Group1", 'Table'[Count]>=10&&'Table'[Count]<=12,"Group2", 'Table'[Count]>=13,"Group3")2. Set the color for the [Switch] column.
3. Result:
If you need pbix, please click here.
Grouping Values in Pie Chart.pbix
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
