Forum Discussion

Viola's avatar
Viola
Frequent Visitor
9 years ago
Solved

waffle chart with survey responses

Hello everyone,  I am currently trying to display my survey results using waffle chart. My responses are in text format therefore i need to add a new coulmn that will calculate the values of each re...
Custom Visuals
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    Viola

     

    I do not know about your data table, so I create a test table like below. In such scenario, we can create two measures to calcuate the responses for each type and all types.

     

    Measure_Count = 
CALCULATE ( COUNTROWS ( Table1 ), ALLEXCEPT ( Table1, Table1[Response] ) )
    Measure_All = 
CALCULATE ( COUNTROWS ( Table1 ), ALL ( Table1 ) )

     

     

     

    Best Regards,
    Herbert

v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Viola

 

I do not know about your data table, so I create a test table like below. In such scenario, we can create two measures to calcuate the responses for each type and all types.

 

Measure_Count = 
CALCULATE ( COUNTROWS ( Table1 ), ALLEXCEPT ( Table1, Table1[Response] ) )
Measure_All = 
CALCULATE ( COUNTROWS ( Table1 ), ALL ( Table1 ) )

 

 

 

Best Regards,
Herbert

  • Viola's avatar
    Viola
    Frequent Visitor
    9 years ago

    Excellent! Thank you so much! That is exactly what i was looking for.

    • v-haibl-msft's avatar
      v-haibl-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      Viola

       

      You can mark the right answer as solution so that others who have the same problem can find the correct solution quickly.

       

      Best Regards,
      Herbert

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    v-haibl-msft 

    The text under each waffle chart is overlapping, please see the below image. Are there any solutions to this please?