Sorting multiple columns by High, Medium, Low

[MisterDave]

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. 

[v-ljerr-msft · Accepted 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

[MisterDave]

Many thanks. I'll give it a go later and report back.