Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi! I'm having trouble with a pie chart graph. I have a set of defined categories but for one of them I get it represented in three different groups. I don't have any idea why this is happening.
Thanks in advance
Solved! Go to Solution.
Hi! i've found the solution to my problem.
The groups that I were using for my legend were generated in a calculated column.
The thing is that I also had a calculated column for sorting that groups. I updated the DAX measure to add more groups in between but I forgot to change my measure for sorting resulting in the problem mentioned.
Thanks for your time!
HI @Anonymous ,
Can you try displaying categorical labels along with labels on pie-chart?
See if it tells you what extra pie it is showing there.
Share the screenshot as well.
Sorry, I didn't understand you.
This are the slices shown:
HI @Anonymous ,
I meant the following as this will tell you what that extra pie is getting displayed on your pie-chart though it doesn't show it on the LEGEND:
Also I am now not very sure if I understand your question. What do you mean by I have a set of defined categories but for one of them I get it represented in three different groups?
Here is another capture:
I'm having three slices displayed for the group "W7-W10" when it should be only one.
Hi @Anonymous ,
Please export the data to excel, compare those 3 heads, they look like same but should be different by a space (white space), in the beginning/end or in middle somewhere?
Hope it helps.
Hi,
Share the link from where i can download your PBI file.
HI @Anonymous ,
What happens when you move this working week group to Details section rather than Legend section?
HAve you tried moving this working week group and your count to a normal table visual rather than pie-chart? (attach a screenshot if possible)
I can't judge exactly without seeing the data.
Hi! i've found the solution to my problem.
The groups that I were using for my legend were generated in a calculated column.
The thing is that I also had a calculated column for sorting that groups. I updated the DAX measure to add more groups in between but I forgot to change my measure for sorting resulting in the problem mentioned.
Thanks for your time!
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!