Forum Discussion
DuncanP
Advocate II
Advocate IIPower BI Calculation Group subtotals
Hi I'm using calculation groups in Power BI Desktop, but I've found out that subtotals are not displayed (which does make sense as you wouldn't want to add together Current and PY totals for exam...
v-jingzhang
Community Support
Community SupportHi DuncanP
If you are using a Matrix visual, it is easy. In Format pane, under Subtotals, turn on Column subtotals.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
DuncanPAdvocate II
Advocate IIHi v-jingzhang
Thank you for replying, but unfortunately that doesn't work for calculation groups, and in fact the option is missing altogether!
In my example, Current and PY are two calculation items in a calculation group.
Duncan