Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Advocate I
Advocate I

Custom Sorting in PowerBI?

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: 

PowerBI Sorting Question.png


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


Thank you!

Microsoft Employee
Microsoft Employee



You can create a table like following one and create relationship with the original table.

Custom Sorting in PowerBI_1.jpg


Then create a calculated column in original table with following formula.

Column = RELATED( Table2[ID] )

Custom Sorting in PowerBI_2.jpg


At last, select the Type column and make it sorted by above created column.

Custom Sorting in PowerBI_3.jpg


Custom Sorting in PowerBI_4.jpg


Best Regards,


View solution in original post


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?

Not applicable

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

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.

@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!



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:

New Table.png


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: 

Inserting column.png


Any advice? 

@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. 

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors