Forum Discussion

wdvro's avatar
wdvro
Frequent Visitor
3 years ago
Solved

Visualisation multiple choice answers

Hello,

 

I took a survey where some questions allowed respondents to tick multiple response options. In my report, I would have liked to show the proportion of respondents who ticked a particular answer option, visualised in a bar chart.

With a simple example, this looks like this:

 

Data table:

 

 

How I want this to be displayed in Power BI (now calculated in Excel):

 

 

Thanks in adance

Need Help
  • JoeBarry's avatar
    JoeBarry
    3 years ago

    Hi wdvro 

     

    You need to first find out how respondants there are. Presuming there is a ResponseID or UserID in the Data ?

    Reposnses/Users = DISTINCTCOUNT('Table'[ResponseID])

     

    Then Create this

     

    % = DIVIDE([Responses/Users], CALCULATE([Responses/Users], ALL('Table')))

     

    Convert to %

     

     

     

    Thanks

    Joe

     

    If this post helps, then please Accept it as the solution

2 Replies

  • JoeBarry's avatar
    JoeBarry
    Solution Sage
    3 years ago

    Hi wdvro 

     

    You need to first find out how respondants there are. Presuming there is a ResponseID or UserID in the Data ?

    Reposnses/Users = DISTINCTCOUNT('Table'[ResponseID])

     

    Then Create this

     

    % = DIVIDE([Responses/Users], CALCULATE([Responses/Users], ALL('Table')))

     

    Convert to %

     

     

     

    Thanks

    Joe

     

    If this post helps, then please Accept it as the solution

    • wdvro's avatar
      wdvro
      Frequent Visitor
      3 years ago

      Thank you, just what I was looking for!