Power BI Guide  ·  Updated July 2026  ·  11 min read  ·  Flexa Intel Team

Power BI Dynamic Columns: Show & Hide Without Republishing (2026)

1. Why Dynamic Columns Are Hard in Power BI

Power BI separates two distinct roles: the report author (works in Power BI Desktop, configures visuals, publishes) and the report consumer (works in Power BI Service, views and filters but cannot modify visual configuration). This separation is intentional — it prevents consumers from breaking reports — but it creates friction when business users legitimately need to control which columns appear.

The most common scenario: a Finance team uses a Matrix report with Revenue, COGS, and Gross Profit columns. A CFO asks "can you also show me Headcount?" A BI developer adds the column in Desktop and republishes. Two weeks later, the CFO asks "can you hide Headcount for the board version?" Another Desktop session, another republish. This cycle is the core problem that dynamic column approaches solve.

2. Four Approaches — Comparison at a Glance

3. Method 1: Field Parameters

Field Parameters create a parameter table that lists measures or fields. A slicer connected to the parameter lets users choose which measures appear in a visual. The visual updates dynamically based on the slicer selection — no republish needed once the parameter is set up.

When to use Field Parameters

• You have a defined set of metrics users need to switch between (Revenue, COGS, Gross Profit, Headcount)
• The column count won't change — adding a new metric still requires Desktop
• You want a native solution with no additional cost

Step-by-step: Field Parameters

1. Enable Field Parameters. File → Options and settings → Options → Preview features → check "Field parameters" → restart Power BI Desktop.
2. Create the parameter. Modeling tab → New parameter → Fields. In the dialog, name the parameter (e.g. "Column Selector") and add the measures or fields you want users to switch between. Click Create.
3. Power BI automatically: creates a parameter table, adds a DAX measure for each field, and adds a slicer to the report canvas.
4. Add the parameter to your visual. In your Matrix or Table visual, drag the parameter's Field value to the Values field well (replacing or alongside your existing measures).
5. Configure the slicer. The auto-created slicer controls which columns appear. Set it to multi-select so users can show multiple columns simultaneously. Optionally rename slicer items for clarity.
6. Publish. In Power BI Service, users use the slicer to show/hide columns — no Desktop access needed.

Field Parameters M code (for reference)

// Auto-generated DAX for a Field Parameter named "Column Selector"
Column Selector = {
    ("Revenue", NAMEOF('Sales'[Revenue Measure]), 0),
    ("COGS", NAMEOF('Sales'[COGS Measure]), 1),
    ("Gross Profit", NAMEOF('Sales'[Gross Profit Measure]), 2),
    ("Headcount", NAMEOF('HR'[Headcount Measure]), 3)
}

4. Method 2: Bookmarks with Buttons

Bookmarks capture the state of a report page — which visuals are visible, which filters are applied, and which slicers are selected. By creating multiple bookmarks (each capturing a different column layout) and linking them to buttons, users can switch between pre-built column configurations with a single click.

When to use Bookmarks

• You have 2–3 fixed layouts that users toggle between (e.g. "Summary view" vs "Detail view")
• The layouts are significantly different — not just column visibility but entire visual arrangements
• You don't want to use Field Parameters for some reason (e.g. the layout changes are too complex for a slicer)

Step-by-step: Bookmarks for column toggle

1. Build two versions of your visual. Create two Matrix visuals on the same report page — one with the "summary" columns (Revenue, Gross Profit, Net Income) and one with the "detail" columns (Revenue, COGS, Gross Profit, OpEx, EBITDA, Net Income). Overlap them in the same position.
2. Open the Bookmarks pane. View → Bookmarks → Add.
3. Create Bookmark 1 (Summary). Show only the summary visual, hide the detail visual. Add a bookmark — name it "Summary View." Right-click the bookmark → update to capture current state.
4. Create Bookmark 2 (Detail). Show only the detail visual, hide the summary visual. Add another bookmark — name it "Detail View."
5. Add toggle buttons. Insert → Buttons → Blank. Label one "Summary" and one "Detail." In the button's Action settings, set Type = Bookmark and select the corresponding bookmark.
6. Publish. Users click the buttons to switch between layouts in Power BI Service.

5. Method 3: DAX BLANK() Trick

When a measure returns BLANK() for all rows in a column, Power BI hides the column header in the Matrix visual. This behavior can be used to make columns appear and disappear based on a What-If parameter slicer — without republishing.

Step-by-step: BLANK() trick

1. Create a What-If parameter. Modeling → New parameter → Numeric range. Set: Minimum = 0, Maximum = 1, Increment = 1, Default = 1. Name it "Show Headcount." Click OK — Power BI adds a slicer and a measure automatically.
2. Create a conditional measure. For each column you want to make hideable, create a wrapper measure:

Headcount (Conditional) =
IF(
    [Show Headcount] = 1,
    [Headcount],   -- show the real value
    BLANK()        -- return BLANK to hide the column
)

3. Replace the original measure in the Matrix with the conditional measure. The column now shows when the parameter = 1 and disappears when parameter = 0.
4. Format the slicer. Change it to a toggle button style (slicer → Format → Slicer settings → Style → Tile) for a cleaner UI. Label it "Show/Hide Headcount."
5. Publish. Users toggle the slicer in Power BI Service to show or hide the column. No Desktop needed.

Multi-column toggle with one parameter

To control multiple columns with a single parameter, use an integer range instead of 0/1:

-- Parameter: "Column View" with values 1 (Summary), 2 (Detail), 3 (Full)

COGS (Conditional) =
IF([Column View] >= 2, [COGS], BLANK())

OpEx (Conditional) =
IF([Column View] >= 2, [OpEx], BLANK())

EBITDA (Conditional) =
IF([Column View] = 3, [EBITDA], BLANK())

6. Method 4: Flexa Tables (Full Self-Service)

Flexa Tables is fundamentally different from the three native approaches: instead of pre-defining which columns users can choose, it gives users the ability to add, remove, and reorder any column — including variance columns (MoM, YoY, Actual vs Budget, Actual vs Forecast) that don't exist as DAX measures in the data model.

What Flexa Tables lets users do in Power BI Service

• Show/hide existing columns — click a column header to remove it from the view; click the + button to add it back
• Add variance columns without DAX — click + column → select MoM, YoY, YTD, Actual vs Budget, Actual vs Forecast → column appears instantly with the calculated variance
• Reorder columns — drag column headers left or right to change the display order
• Select comparison periods — choose which two periods to compare for a variance column, directly in the published report
• Save views — save a custom column configuration so it persists between sessions

Setup: Flexa Tables in Power BI Desktop

1. Install from AppSource. Insert → More Visuals → AppSource → search "Flexa Tables" → Add. Free trial, no credit card required.
2. Add to report canvas and resize to full width.
3. Configure base columns. Drag your row dimension to Rows, your measure(s) to Values, and optionally your date/period dimension to Columns — same as the Matrix visual.
4. Publish to Power BI Service. Users can now add, remove, and reorder columns themselves. Variance columns (MoM, YoY, etc.) appear as options in the + column menu even if no corresponding DAX measures exist in the model.

7. Decision Guide — Which Method to Use

FAQ

How do I show and hide columns dynamically in Power BI without republishing?

Four approaches: Field Parameters (switch between predefined measures via slicer), Bookmarks with buttons (toggle between preset layouts), DAX BLANK() trick (hide columns conditionally based on a parameter), and Flexa Tables (the only method that lets users add columns that weren't predefined, including variance columns). Choose based on how much flexibility users need after publishing.

What are Field Parameters in Power BI and how do they work?

Field Parameters create a parameter table containing a list of fields or measures. A slicer connected to the parameter controls which fields appear in a visual. Users select one or more fields from the slicer and the visual updates — no republish needed. Field Parameters must be enabled in Preview features (Options → Preview features → Field parameters) and defined in Desktop before publishing. Enable the preview feature in File → Options → Preview features.

Can users add columns in Power BI Service without going back to Desktop?

Not with native Power BI visuals — Matrix and Table visuals lock their column configuration after publishing. The only way to add new columns in Power BI Service without Desktop is with Flexa Tables from AppSource, which lets users add columns (including MoM, YoY, Actual vs Budget) directly in the published report without DAX or IT involvement.

How do I use the BLANK() trick to hide columns in Power BI?

Create a What-If parameter (0 to 1), then wrap your measure: Column = IF([Show Parameter] = 1, [Original Measure], BLANK()). Use the conditional measure in your Matrix visual. When the parameter slicer is set to 0, the column disappears. This works in published reports without republishing, but each hideable column needs its own wrapper measure, and it only works in the Matrix visual (not Table visual).

Why can't I add columns to a Power BI Table visual after publishing?

Power BI's Table and Matrix visuals are configured in Desktop and locked when published to Power BI Service. Report viewers can filter, sort, and drill but cannot modify field configuration. To give consumers column control, use Field Parameters (switching between predefined options) or Flexa Tables (full add/remove/reorder freedom in Service).

What is the easiest way to let Finance users choose which columns to see in Power BI?

Flexa Tables — install once, publish, and Finance users can show/hide columns, add variance columns (MoM, YoY, Actual vs Budget), and reorder columns themselves in Power BI Service. No ongoing developer involvement. Field Parameters is the best native alternative but requires predefined options and doesn't support adding new variance columns.