Forum Discussion

DLB13's avatar
DLB13
Helper I
6 years ago

Combining Answers for Percentage

Hi there - 

 

I have a set of questions with a likert scale (strongly disagree to strongly agree). I'd like to display this in power bi as "xx% of respondents agreed that....", with the % being the combination of respondents who answered "agree" and "strongly agree." I'm coming up short on how to do this - any tips? Many thanks!

Need Help

7 Replies

    • DLB13's avatar
      DLB13
      Helper I
      6 years ago

      Hi there -

       

      Thanks for reaching out so fast! Unfortunately I can't share the data, but the format is really simple. Respondents in column A, likert choice selection in column b (so one of five options: strongly disagree, disagree, neutral, agree, strongly agree). Does this help?

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        have u found a solution yet? Im having the same scenario too

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    6 years ago

    Hi DLB13 

     

    Not quite understand what you're looking for. You might consider providing your dummy pbix.

    You can upload it to the onedrive for business and share the link here. please don't forget to disclose the expected results and remove the confidential info.

    If you'd like to combine columns, you might check:

    https://support.microsoft.com/en-us/office/merge-columns-power-query-80ec9e1e-1eb6-4048-b500-d5d42d9f0a8d#:~:text=Select%20two%20or%20more%20columns,columns%20and%20click%20Merge%20Columns. 

     

    • DLB13's avatar
      DLB13
      Helper I
      6 years ago

      Here is a very simple data set.

       

      Basically, in power BI, I want to be able to display "xx% of respondents agree", with the percentage calculating (number of "strongly agree" + number of "agree")/number of total respondents. 

      RespondentQuestion 1
      1Agree
      2Strongly Agree
      3Disagree
      4Neutral
      5Neutral
      6Agree
      7Agree
      8Strongly Agree
      9Strongly Disagree
      10Agree
      11Agree
      12Strongly Agree
      13DIsagree
      14Neutral
      15Disagree
      16Agree
      17Agree
      18Neutral
      19Strongly Agree
      20Disagree
      21Strongly Disagree
      22Neutral
      23Agree
      24Agree
      25Strongly Agree
      26Neutral
      27Disagree
      • DLB13's avatar
        DLB13
        Helper I
        6 years ago

        Just bumping this... hoping someone can help!

  • DLB13's avatar
    DLB13
    Helper I
    5 years ago

    Bumping as I still have this question. I have to do this for a LOT of variables, so I'm hoping for a solution other than typing out a measure for each of them!