Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Viola
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
v-haibl-msft
Employee
Employee

@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
v-haibl-msft
Employee
Employee

@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

Anonymous
Not applicable

@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

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

@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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.