Forum Discussion
Likert scale graphs
Hi all, I have a data base from a survey with more than 100 columns with Strongly disagree, agree, neutral, agree, strongly agree data for each column. I need transport this result into gra...
Hi Anonymous ,
In power bi desktop visual, the default is to sort by first letter for using text as legend. So creating a sorting column is a relatively straightforward way to achieve the requirements.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
v-yingjl i was trying to find a solution as i have more than 200 columns to sort, and wont be feasible to create one sort column for each one.
It's a while since I've attempted one of these Likert questions. I think I remember that unpivotting the question columns is the way to go.
You should then be able to create a sorting dimension to customise the sort order.
