Forum Discussion

gonrodrigues's avatar
gonrodrigues
Helper III
10 years ago
Solved

Waffle chart

An easy question: in waffle chart, my group is 'gender' and what should i have in excel to value?   Thanks!
Need Help
  • kiewic's avatar
    kiewic
    10 years ago

    Hello,

     

    Waffle Chart author here.

     

    The Waffle Chart works nice if all the input values are between 0 and 100, but if one of them is over 100, then, the maximum value in the input is considered the 100% value and the rest of the values are calculated using cross multiplication.

     

    There is a nice way to fix this, and it is using the Maximum value column. For example, if the values are greater than 100, then, you can provide what value is 100% in the Maximum value like this:

     

     

    Group,   Value, Maximum Value
Female,   3400,          6000
Male,     2600,          6000

     

     

    Then Female will become 57% and Male will become 43%.

     

    Let me know if this does not solve the problem.

     

gonrodrigues's avatar
gonrodrigues
Helper III
10 years ago

Hey Anonymous

 

I have an excel DB and i want to create a waffle chart in Power Bi Desktop.

 

Excel DBPBi Desktop

The results should be 46% and 54% of a total of 6000 headcount and not the percentage of "feminino" when compared to a total of 'masculino' (3240).

 

Thanks!

Anonymous's avatar
Anonymous
Not applicable
9 years ago

What worked for me was to create a Measure that calculates all items in the report excluding any items you would want to filter out. Then using this measure as your max value. This allows your data to display properly all the time, and not to rely on a fixed value. 

 

Example: 

 

Create a measure named "Max Value Example" as follows: 

Max Value Example = CALCULATE(count('Gender'[ItemID]),'Gender'[Male/Female]<>"")

 

I filtered blank values but if you have no null values you can just do a Count for all items.