Forum Discussion
Waffle visualisation not working
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 th...
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
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 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! :-)
It's my pleasure, have a nice day !