Waffle visualisation not working

[Anonymous]

I have a table which I've grouped into just two rows - the Range which consists of 'Within 12 months' 'Within 3 months' and 'Within 1 month' 

And the count of how many times each range appears in the dataset. 

I want a waffle chart to show the three ranges and the percentage of each count against the total. 

I know the percentages are

'Within 12 months' = 81.8% 

'Within 3 months' = 12.27%

'Within 1 month' = 5.9%

In the Category Data of my chart I have the Range

Under Values I have Count (which is the Sum of Count)

Under Max Values I have Count (also the sum)

However, the waffle is showing

'Within 12 months' = 100%

'Within 3 months' = 15%

'Within 1 month' = 7%

I have the pbix file I can send but I am unable to attach it to this post for some reason. 

What the hell am I doing wrong????

[Anonymous · Accepted solution]

Hi, 

You need to add a measure (right click your table, add measure) and enter the following formula :

Total MEASURE = CALCULATE ( SUM ( 'Table'[Count]); ALL('Table'))

This will compute the total of your Count column.

Then just add your Total measure to MAX Value of your Waffle visualisation.

Here is a screenshot of what I did (my Power BI is in french but it's not any different from yours).

Tell me if you encounter any problems, 

Regards,

Etienne

[Anonymous]

@Anonymous merci!

I thought it might be to do with the max measure - I was trying to create a max aggregation but it didn't work, your measure has finally fixed my visualisation thank you so much! 🙂 

[Anonymous]

It's my pleasure, have a nice day !