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

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
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

22LACMT's avatar
22LACMT
Helper III
3 years ago

I have 5 columns that need to be reordered in different ways in my fact table.  I created 5 seperate demention tables with the column and a new column that attched a resort to them.  then I sorted on the that new column.  worked great and the data reorganized at the data level in the demention table.  however,  when I use that resorted field from the demention table the data does not reorganize.... please please help im so stuck. 

 

I can not reorder my main table as there are 5 different fields that need to be reordered for different visuals.