Forum Discussion
Solved
Index multiple collumns
Hi I have a table with survey data with multiple collumns featuring the following; -Strongly disagree -Disagree -Agree -Strongly Agree In my visuals they are sorting in alphabetical order...
Hi,
Read up on "Unpivot Other Columns" in Power Query. Create another table with 2 columns - Response and Order. Sort the Response column by the Order column. Create a relationship from the Value column of the Fact table (which has the responses) to the new table. To any visual, drag Response from the new table.
Hi PlenLXox ,
May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.
Thank you.