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 ,
We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.
Best Regards,
Chaithra E.