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
6 years ago

For clear view please refer to the below images Before Sorting and After Sorting why the values are changing to 100% for each category.

 

Please note i have exactly followed the same procedure as mentioned in the solution.

 

 

Before Sorting

 

After Sorting

 

theblackknight's avatar
theblackknight
New Member
1 year ago

Hi there,

It seems like when calculating percentage for each category after sorting, you will have to make a slight change to your formula to also aggregate based on the new column created in original table.

for example:

Here earlier I was only aggregating on 

'AggregateGradingData'[vw_REPGradingApprenticeFinalGrade.AM_Grade] in all because of which all of the grades were showing 100%, after I made change to include thew new calculated column as well, it started working like magic.

I hope that helps.

here are screenshots of changes before and after: mark that am grade pos is calulated column using related:

resultant visual:


after change in formula:


resultant visual: