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

Hi Everyone,

 

This option seems to be completely not working when i tried the same procedure and sorted the stacked column chart my chart started showing all as 100% for all items.

 

Suggest .

 

Thanks,

Abhilash

  • 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: