Forum Discussion

iGi's avatar
iGi
Advocate I
9 years ago
Solved

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...
Custom Visuals
Dashboards
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    iGi

     

    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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Awesome tip!

I was struggling to reorder certain data, but this worked like a charm!

 

Thanks a lot!!

mvanwyns's avatar
mvanwyns
Advocate I
8 years ago

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

 

I just can't get this crap worked out

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

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

  • s--turn's avatar
    s--turn
    Helper II
    2 years ago

    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?