Custom Sorting in PowerBI?

[iGi]

Hello all, 

Seeing as how helpful people were with my last two questions, I thought I'd ask another, which has been nagging me. 

I'm aware of the sorting function in graphs, but that seems to sort the items alphabetically. 

What I'm hoping to do is sort non-alphabetically, in an order that makes sense otherwise - highest to lowest, or whatever the case. 

See here: 

I'd like it to read Critical, High, Medium, Low. Is there anything I can do here? 

Thank you!

[mvanwyns]

All these workarounds for just a simple sort task, unbeleivable how difficult it is

I just can't get this crap worked out

[s--turn]

I agree this is a HUGE faff for such an obvious requirement!  I am sure this is possible in Tableau.  Is there anywhere this has been logged as a suggestion that we can upvote, and try and get it on the roadmap?

[Anonymous]

Agreed! This is such a basic feature, why it requires such a workaround seems absurd!

[forzajoensy]

Great tips! Thanks! Its a long way around from what should be a custom sort or drag feature link in a pivot table. Will be available some time I guess.

[iGi]

@v-haibl-msft I got it! I was editing the query earlier, not realizing that I should just go through the Modeling tab under the table. 

Anyway, I was able to select "ID" from the new table: 

Sorted the Risk Rating column as you said, saved and the change took. 

Learned something new today. 🙂

Thank you!

[iGi]

@v-haibl-msft

Since I'm unfamiliar with this, I'm getting stuck at adding a new column and referencing the ID column from the newly created table. 

Here is where I am: 

1. Added a new table with Risk and ID columns:

2. Created a link between the two tables on Risk Rating and Risk:

3. Clicked on Custom Column and the only columns available to me are those in the original, primary table and I don't know how to reference the new "Risk Order" table in the formula: 

Any advice? 

[iGi]

@v-haibl-msft Wow! Didn't even think of doing that. Thank you! I'll give this a try to see if it will work with the larger table that I'm using here. 

On a separate note, how did you learn this? It resembles SQL to me.