Forum Discussion
Matrix subtotals issue
Hi all, I have a table with two rows and two columns: value currency 7.485 EUR 12.548 CNY I created a matrix defined to have the sum of the values by currency. What I expect i...
Anonymous ,
Drag the calculated column below to Rows as well and take a look at Using drill down with the Matrix visual.
Column = Table1[currency]
- https://community.powerbi.com/t5/Desktop/matrix-visual-show-total-only/m-p/472465#M219588
- https://community.powerbi.com/t5/Desktop/Matrix-remove-white-space/td-p/442817
Hello v-chuncz-msft,
thanks a lot for your answer. Sorry for the delay but i was not able to test your suggesteed solution till today.
Unfortunately this solution is not working totally, because the global totals are already in not separated sum (as picture show).
Thank you so much :)