Clément Théry on 18 May 2020 13:09:45
Would be great to be able to do the same likert bar graphs as in Microsoft Forms. Graph in Forms is very nice but not as interactive as in Power BI.
- Comments (5)
RE: Likert graphs as in Microsoft forms
Adding my plug for integrated Likert visual options. Most of the work-arounds that folks have suggested here and in other forums advocate unpivoting data in order to display Likert responses in a table visual. That's great, except that often the data source is built from data that came from disparate sources (e.g., a Microsoft Form that has a mix of short/long answer questions, Likert questions, choice questions, etc.). In that case unpivoting the Likert columns can duplicate data from other columns in a table, rendering other measures inaccurate unless you can determine an appropriate way to break out the Likert data into a different table and create relationships. It's messy.This is a good example of where Microsoft should be thinking end-to-end in its product strategies. If the branded data collection tools (e.g., Forms, CustomerVoice) can collect the data in a certain way, the data storage AND data reporting tools should also support that same methodology right out of the gate.
RE: Likert graphs as in Microsoft forms
Can't the code displaying the Likert in Forms be easily ported to PowerBI?
RE: Likert graphs as in Microsoft forms
No so detailed, but here is a work-around...
https://community.powerbi.com/t5/Desktop/Microsoft-Form-Likert-responses-in-PowerBI/td-p/1187402
RE: Likert graphs as in Microsoft forms
This is so critical; this is the best way to interpret likert question data, and this is an incredibly common type of data. A survey from Microsoft forms visualized likert questions and then in Power BI you lose the ability!
Also, if you have a long list of likert questions and unpivot the columns, with such a tool you would with one visual get all the questions down the side with a diverging stacked bar chart for each question.
It is important to include an option to put one answer choice off the right, separate from the diverging stacked bar chart, for "N/A" answers.
For the benefit of search indexing this idea: "Strongly Disagree" "Disagree" "Neutral" "Agree" "Strongly Agree"
RE: Likert graphs as in Microsoft forms
Tableau does a very nice job of displaying Likert information so you can make comparisons across questions.