Hide Empty Columns
You can now hide empty columns, while keep all custom columns visible. (available from v7.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:
-
If we chance the slicer to 2020, then Actuals (-2Y) is set to 2018, for which we have no data, leaving it empty:
-
Turning on the option to Hide Empty Columns will hide these:
-
Add a custom column after Company 1. The custom column is now anchored to that the Company 1 column:
-
Set the slicer to 2019. Company 1 does not have any data for 2019, so both Company 1 and After Co1 disappears:
-
Turn on "Show Items with no data" for the Column headers, and we see the empty columns:
-
Turn on the option Hide Empty Columns to hide them again.
-
Now you also have the option to always show Custom Columns, meaning After Co1 is visible, even when Company1 is gone:
- Home
- Security
- Getting started
- Adding data to the visual
- Title
- Column styling
- Row expansion
- Row and Column totals
- Column expansion
- Values options
- Custom subtotals - rows
- Row styles - appearance
- Hiding rows
- Hiding columns
- Hide empty rows
- Formatting
- Custom columns
- Overriding column calculations
- Ragged hierarchies
- Web URL
- Applied steps
- Data Bars
- Export to Excel
- Thousand and Decimal Separator
- Measure Placement
- Calculations
- Theming
- Find Visual Version