Hide Empty Columns - Profitbase/PowerBI-visuals-FinancialReportingMatrix GitHub Wiki

You can now hide empty columns, while keep all custom columns visible. (available from v7.1)

Example where you want to hide a measure if not relevant:

  1. One measure showing the selected period, and another showing the same value two years earlier. Based on the slicer, Actuals show 2021, and Actuals (-2y) shows 2019: image

  2. If we chance the slicer to 2020, then Actuals (-2Y) is set to 2018, for which we have no data, leaving it empty: image

  3. Turning on the option to Hide Empty Columns will hide these: image

Example where you want to always show custom columns:

  1. Add a custom column after Company 1. The custom column is now anchored to that the Company 1 column: image

  2. Set the slicer to 2019. Company 1 does not have any data for 2019, so both Company 1 and After Co1 disappears: image

  3. Turn on "Show Items with no data" for the Column headers, and we see the empty columns: image

  4. Turn on the option Hide Empty Columns to hide them again. image

  5. Now you also have the option to always show Custom Columns, meaning After Co1 is visible, even when Company1 is gone: image