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
You need to add custom sorting to your columns.
Check if the following blog helps:
https://radacad.com/sort-a-column-with-a-custom-order-in-power-bi/