Enable column expansion - Profitbase/PowerBI-visuals-FinancialReportingMatrix GitHub Wiki

#Premium feature

Follow these 3 steps to enable column expansion.

  1. In the Formatting pane, enable column expansion by switching the toggle to On

Enable column expansion

  1. In the Fields pane, add at least 2 fields to the Columns bucket, for example Year and Month

Add fields to Columns bucket

  1. You should now be able to collapse columns with automatically summarized totals and expand to view details.

Expanded and collapsed columns example