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.
sort by which column? if not, what's the expected output based on the sample data you provided?
I am looking for approx 10 collumns in my table to be ordered the following:
Stongly Disagree - 1
Disagree - 2
Agree - 3
Strongly Agree - 4
So I can display these in the right order in a visual.
thanks.
what if one row is 1 and 4, another is 4 and 1 for different columns? pls clarify your logic clearly.