cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

## Visualize data as percentage of total respondents rather than responses

I have survey data where respondents could select more than one response. Because of this my answers are not to a total of 100%. See raw data export attached. I would like to visualise this question in a bar chart where each bar reflects the correct percentage. At the moment i have the data in a bar chart with the count correct reflecting number of responses. I need to do a calcualtion so that the bars are in % and not a perectange of the grand total as this changes the data in proportion to 100%.

Please can someone advise how to do the next step - calculate the bars to be reflective of each factor divided by the total number of respondents for this question 806. For example 457/806 = 56.7%

1 ACCEPTED SOLUTION
Super User

@HKeeling , Based on what I got, Assume the response is a measure

You can have % of GT is divide([response], calculate([response], allselected() ) )

if you do not want gt change based on slicer

divide([response], calculate([response], all() ) )

2 REPLIES 2
Community Support

Hi @HKeeling ,

Has the problem be solved?

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
Super User

@HKeeling , Based on what I got, Assume the response is a measure

You can have % of GT is divide([response], calculate([response], allselected() ) )

if you do not want gt change based on slicer

divide([response], calculate([response], all() ) )