Forum Discussion
likert Chart
- 8 years ago
Hi jason435,
By my tests, if you want to replicate your likert chart to Power BI Desktop, it haven’t been supported currently.
You could give feedback via https://ideas.powerbi.com/forums/265200-power-bi and vote your idea up.
Best Regards,
Cherry
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):