Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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
@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.
That seems like behavior. The subtotal move down, but not the label.
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |