Simple sort issue

[Hopeisgood1]

For the love of god, I am not able to sort this priority in the visualization. I need the High and Medium in the order of Low, Medium, High, and Critical.

I created a table to sort by column the Order. 

Then I tried the sort by axis/legend - still wrong

What am I missing or doing wrong here??

[Gabry]

Hey @Hopeisgood1 

can't you just add a number before the text? 
Like 0 - Low, 1 - Medium, 2 - high ecc?

Not a satisfactory solution?

[Hopeisgood1]

Won't work as the priority column has a relationship with the main table of the same name. 

[Gabry]

Don't modify the column used for the relationship, but add a new column in the table Prioritisortorder with the number as prefix, then use this new column for the visual leggend.

Now I'm thinking that if you sort the priority column by order column should work also.

Go in the data view, then select the priority column, then sort by order column

[Hopeisgood1]

Tried - Nope 😕

I even tried to sort by legend as well as Details...nope

[Gabry]

Also, it seems that in the screenshot you provided, you’re not sorting the priority column by order but rather sorting the order column itself.

Additionally, if you set up the order column this way, you should use the order column as the legend instead of the priority column.

[Gabry]

Are you sure? I've tried with simple data and both the methods worked good.

Could you load your pbix?

[Hopeisgood1]

I am not able to share the pbix due to company's policies 😕 

Is it possible you can show me the snapshots to what you did?

[Gabry · Accepted solution]

Here is the pbix .

Please select the Priority column, then click on Sort by and choose the Order column.

[Hopeisgood1]

THANK YOU!!!!