Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello all
I'm trying to sort multiple columns which all have the same values (High, Medium, Low) so that when I visualise them they show in order of severity. I can do it for an individual column by creating a table and using that to sortby but the new column will only sort one column. Equally, if I create a new table and column for each one I wish to sort, I get a message saying ''There can't be more than one value in 'New column' for the same value in Risk 2' (where New Column is the column created to establish the hierarchy of H,M,L).
The data looks something like this:
Location Risk 1 Risk 2 Risk 3 Risk 4
Country 1 High Low Medium High
Country 2 High Medium Low Medium
Country 3 Low Low Medium Low
Can any body help? THere must be an easier way to do this! All I want is to be able to sequence the axes in my visualisations by H,M,L rather than alphabetically or numerically.
Many thanks.
Solved! Go to Solution.
Hi @MisterDave,
I'm wondering if could try unpivoting the risk columns first in Query Editor, then sort the only Value column(of course you can rename it) to get the expected result in your scenario.
For more details about how to Pivot and Unpivot with Power BI, you can refer to this article.
Regards
Hi @MisterDave,
I'm wondering if could try unpivoting the risk columns first in Query Editor, then sort the only Value column(of course you can rename it) to get the expected result in your scenario.
For more details about how to Pivot and Unpivot with Power BI, you can refer to this article.
Regards
Many thanks. I'll give it a go later and report back.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |