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.
Ashish_Mathur
Super User
Super UserHi,
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.