I created in PBI a simple matrix with various types of selection for the time period.
To optimize the table I am looking for a way to show column total only if mininum 2 columns (=periods) are available.
Status Quo:
Solution I am looking for:
Is this possible?
Not per se, in a matrix visual either you show all the totals/subtotals or you don't. How I usually handle these cases is through bookmarks.
1. Duplicate the same visual you have but leave all totals turned off. Then hide it with the Selection pane.
2. Then create a bookmark showing the one that does have the totals and hides the other one.
3. Create another bookmark to do the opposite (show no totals/hide totals)
4. Use a bookmark navigator button to enable the switch to the user.
Did I answer your question? Give your kudos and mark my post as a solution!
Proud to be a Super User!
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
