How To sort Sort Summary in Hierarchy in Matrix?

[itsmebvk]

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 mentioned below.

L1	A	600
L2	AA	100
L2	AB	200
L2	AC	300
L1	B	300
L2	BA	50
L2	BB	100
L2	BC	150
L1	C	300
L2	CA	100
L2	CB	200

But is there any way i can move the rows subtotals to the end of each Level value. (Note: If I  use subtotal position option as bottom, sub total position is changing but the label of that Level value is not displaying). My requirement is I want to get the output as mentioned below.

L2	AA	100
L2	AB	200
L2	AC	300
L1	A	600
L2	BA	50
L2	BB	100
L2	BC	150
L1	B	300
L2	CA	100
L2	CB	200
L2	C	300

 I am using Direct Query mode, can  you please share any inputs or work around which you have.

[v-shex-msft]

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 · Accepted solution]

@v-shex-msft @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.

[amitchandak]

That seems like behavior. The subtotal move down, but not the label.

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual