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
Hello Ritaf1983 I hope these will do, I've just taken a sample of the data from the survey I'm working on. Length of employment and familiarity with 'X'. I'm trying to use PowerBI to generate graphs similar to the one you can see in the excel file (though I know the likert is in the wrong order there). https://1drv.ms/x/c/a13f09568fd1d70e/EV4rSGi74B1BiebcJXHTX-sBXWOBTpb3cQ6Halr1-mOoUg?e=UEpaii
https://1drv.ms/u/c/a13f09568fd1d70e/EeSvnx_EZx9Egip4W7sWn5cBO4aDUKozDzx2hu_VmdxtRQ?e=TwTVvo
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