Forum Discussion
Likert scale
Hi JamesMoulton
It's important to note that if you're looking to identify trends against seniority, a cluster graph isn't the best tool for the job.
This is because you can only focus on one cluster at a time. Additionally, coloring each category a different color forces the reader to constantly compare it to the legend.My personal recommendation would be to use a Small Multiple graph for each type of response by seniority. The graphs should be colored in the same color scheme, with the intensity of the color corresponding to the strength of the response (strong to weak or vice versa).
For example, the graph in the image
The pbix with both visuals is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Here's how you can do it:
Ensure Likert Scale is treated as Categorical Data:
- In Power Query Editor, ensure that the Likert scale column is loaded as text or categorical data type. If it's currently loaded as a numerical data type, change it to text.
- Right-click on the column header in Power Query Editor, select "Change Type", and choose "Text".
Use a Table Visualization:
- When you're visualizing the Likert scale responses, ensure that you're using a table visualization rather than a chart (such as a bar chart or column chart). This allows you to see each Likert option separately without aggregation.
Ensure Data Model Is Correct:
- Check your data model to ensure that the Likert scale responses are not aggregated at the data model level. They should be treated as individual responses for each respondent.
Check Visualization Settings:
- If you're using a chart visualization and it's aggregating the responses, ensure that the visualization settings are configured to display individual responses rather than aggregating them. For example, in a bar chart, you may need to set the aggregation function to "Don't summarize" or "Do not summarize" for the Likert scale column.
Hi johnbasha33
Thank you for your suggestions, I've followed 1,2, and 4 and still no luck. I'm a little confused by step 3, would you mind explaining how to go about checking this? Would this be within 'model view'?
Thank you!
