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

kunalmishra07's avatar
kunalmishra07
New Member
8 years ago

Hi All, 

Thank you for sharing the solution. 

 

1. By using reference table

2. Conditional Column

 

I was wondering what is the difference between doing it by using Conditional column and doing the same with calculated column. 

 

Steps Followed :-

1. Go to Data Tab

2. Go to Modelling ribon and select New column

3. Create column using reference column according to what we need to sort. 

 

But sorting is not happening and i am getting error that Reference column could not be sort by Calculated column.

 

Request you to throw light on the same.