Forum Discussion

itsmebvk's avatar
itsmebvk
Icon for Continued Contributor rankContinued Contributor
6 years ago
Solved

How To sort Sort Summary in Hierarchy in Matrix?

  Hi Folks,   I am creating a Matrix visualization using SAP Hana Calc View ( Direct Query Mode) which is in Hierarchy format.  When I add level one and level 2 to matrix,I am getting output as me...
Need Help
  • itsmebvk's avatar
    itsmebvk
    6 years ago

    Anonymous amitchandak  I am able to sort on individual level or dimension , but when we are working with hierarchy its not possible to sort it using the method you have suggested. However thanks for your inputs.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI itsmebvk,

I'd like to suggest you take a look at the following blog to create a custom sort table to apply custom sorting.

Custom Sorting in Power BI  
According to your description, it seems like you are works on 'direct query' mode which not able to create a calculated table, maybe you can configure this in datasource side.

Regards,

Xiaoxin Sheng

itsmebvk's avatar
itsmebvk
Icon for Continued Contributor rankContinued Contributor
6 years ago

Anonymous amitchandak  I am able to sort on individual level or dimension , but when we are working with hierarchy its not possible to sort it using the method you have suggested. However thanks for your inputs.