Forum Discussion

jason435's avatar
jason435
Helper II
8 years ago
Solved

likert Chart

Hello All,

 

In Microsoft Forms, when you use a likert question, you get the results in this format. Does anyone know how I can replicate this in Power BI?

 

Many thanks,

 

9 Replies

  • jason435 I've done a quasi Likert from a default Power BI visual. All I needed were 6 measures (1+5) that can be reused.
    If enough interest, I can prepare a sample report and share it here. At its core, the solution is totally basic stuff‌‌.
    Hint: Measure 1 is used to generate white space at the beginning.

     

  • So this isn't a perfect approach, but here's what I did...

     

    First, in Power Query I copied the query, Chose Columns to include only the ID and the Likert Items, and then unpivoted the Likert scale so that I had a zillion rows of Attribute/Value pairs.  Then, I added a Conditional Column (cheating using Column from Examples) to give a numeric value to each of my values.  In my case, Strongly Disagree = -2, Disagree = 1, Neither Agree nor Disagree = 0, Agree = 1, Strongly Agree = 2.

     

    Loading this into the data model, Power BI auto-detected the ID as a key field and built the relationship between my main table and my "Likert Question" table.

     

    To visualize, I just used a horizontal barchart using the Question for the axis and the "Response_Numeric" for the values (using the "Average" summarization), plus a custom X axis label (with a bunch of underscores, since PBI ignored multiple spaces).  I also force-set the X axis so that the Min was -2 and the Max was 2 so that the scale stayed true to the feedback.

     

    It doesn't give the full nuance that the native MS Forms tool does and it's not super-pretty, but it does show the gist of the data as you apply filters based on other demographics.  Here's what it looked like (note that this was just a subset of my data, but it highlights how it looks):

     

    • jason435's avatar
      jason435
      Helper II

      Thanks for looking as well. I'm using a stacked bar for now. 

      • asitm's avatar
        asitm
        Helper III

        Hi jason,

        its been a few years, so not sure if you still looking for the Likert chart. You already mentioned you are using a stacked bar. but if there are improvements that you seek, we can consider building into our visual.
        we are a couple of developers working on a custom visual for Likert chart in power bi. let me know if this is something you will be interested in and we can connect.