Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I don't know if I am missing something, but in a Matrix, is it possible to control what columns trigger subtotals? It seems that every non-measure column triggers subtotals and I have way more subtotals than I need or want.
Thanks
Well i dont know back then
But now is possible in the subtotal section of format.
You have to switch on the "Per row level" option and then it will appear the columns you want to subtotals.
Best regards
@michaeljc70 Unfortunately this is not possible!
Look at my answer here http://community.powerbi.com/t5/Desktop/how-get-Grand-Total-on-Matrix-Visualization-without-the-row/...
To improve the Matrix Vote for these 2 Ideas
Idea 1
Idea 2
@michaeljc70 I'm not aware of any column level controls, but you do have the ability to remove the subtotal row in formatting options.
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |