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.

     

10 Replies

    • gonrodrigues's avatar
      gonrodrigues
      Helper III
      10 years ago

      I really thought it was easy but for some reason i couldnt get the answer :smileysad:

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Hi gonrodrigues,

    Could you please elaborate more details about your scenario? Do you create waffle chart visualization in Excel or in Power BI Desktop? We will appreciate it if you can post relevant screenshot.

    Thanks,
    Lydia Zhang

    • 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
        10 years ago

        Hi gonrodrigues,

         

        Regarding to the WaffleChart visual issues, please directly contact the author. In this link, you can send an email to the author by clicking “Contact Author” as shown in the following screenshot.

         


        Thanks,
        Lydia Zhang

  • kiewic's avatar
    kiewic
    Frequent Visitor
    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

      Yes, after some work i figured that out a few days ago. That was exactly what i did!

       

      Thanks! kiewic

       

      PS: Good job with waffle chart creation :)

    • Viola's avatar
      Viola
      Frequent Visitor
      9 years ago

      Hello, 

      I face some problems as well, all visuals seem to work following your instructions accept one, one column has only answers "Yes", the waffle chart displays 0% in that case? 

      Do you know what this can be. It is all in the same table...

      Thank you in advance for any support on that. 

  • Pallich's avatar
    Pallich
    Frequent Visitor
    10 years ago

    Hello!
    Tell me please, why do not properly display information if i use custom visuals WaffleChart???

    I think, the problem is with the time zone. But how to fix it?

    Thank you.