Forum Discussion
Solved
Sorting multiple columns by High, Medium, Low
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...
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. :smileyhappy:
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. :smileyhappy:
Regards
Many thanks. I'll give it a go later and report back.