Solved: Custom Sorting in PowerBI? - Page 3

iGi · ‎02-13-2017

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!

v-haibl-msft · ‎02-15-2017

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

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

Column = RELATED( Table2[ID] )

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

Best Regards,

Herbert

Custom Sorting in PowerBI?