Forum Discussion
Community ChampionWaffle Chart showing incorrect Percentages
I wanted to change a Pie chart into a waffle chart but the percentages are different.
In my pie chart I have Values: Hours, Category: Data Number of Employees Group
Less than 10 Employees 59.43%
No Employees 22.1%
10 to 50 Employees 14.38%
NULL 2.16%
50 to 100 employees 1.74%
But the Waffle chart shows
Less than 10 Employees 100%
No Employees 37%
10 to 50 Employees 24%
NULL 4%
50 to 100 employees 3%
Over 100 Employees 0%
Why is the percentages different between the pie and waffle chart? I know my less that 10 employees make nearly 60% of the data, not 100. Can anyone help me understand whats going on here?
6 Replies
GlassShark1Helper III
You need to enter a measure in the Max Values field to restrict the visual.
So Category Data = your attribute, Values = sum of your values and Max Values = something like the below:
Max Sum =CALCULATE(SUM('Fact_Tbl'[Value]),ALL('Fact_Tbl'))
Should work then. Please mark as solution if it does 🙂Hi DebbieE ,
It sounds like you're work with a third party custom visual, I'd like to suggest you contact to visual author to get more information about the difference.
Regards,
Xiaoxin Sheng
- DebbieE
Any chance that Power BI could have an official Waffle chart because they look so much nicer than the pie chart?
Hi DebbieE ,
If you click on support, you can find the github link to report issue:
https://github.com/kiewic/PowerBI-WaffleChart/issues
Regards,Xiaoxin Sheng
