Waffle Chart showing incorrect Percentages

[DebbieE]

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?

[GlassShark1]

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 🙂

[v-shex-msft]

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?

[v-shex-msft]

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

[DebbieE]

Ive added this to GitHub

Surely I must be missing the point of the chart though. It cant be displying percentages incorrectly. That would make it unuseable

[DebbieE]

I think I have been missing the point. The waffle chart appears to just be showing the number but its adding a % which is incorrect but I feel better in understanding whats actually happening