cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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 response, what is the formula for that? I have tried several and nothing works, i am able to calculate one value at the time, when adding new measure to the same column i get an error? Anyone know how to solve that issue ? 

I would higly appreaciate as i am stuck with it 2nd day already:( 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: waffle chart with survey responses

@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 ) )

 

waffle chart with survey responses_1.jpg

 

waffle chart with survey responses_2.jpg

 

Best Regards,
Herbert

View solution in original post

4 REPLIES 4
Highlighted
Microsoft
Microsoft

Re: waffle chart with survey responses

@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 ) )

 

waffle chart with survey responses_1.jpg

 

waffle chart with survey responses_2.jpg

 

Best Regards,
Herbert

View solution in original post

Highlighted
Frequent Visitor

Re: waffle chart with survey responses

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

Highlighted
Microsoft
Microsoft

Re: waffle chart with survey responses

@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

Highlighted
Frequent Visitor

Re: waffle chart with survey responses

@v-haibl-msft 

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

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors