Others

How to Add Dynamic Columns to a Power BI Drop-Down Slicer

Chanuka Geekiyanage Oct 9, 2026 868 views

Question details

The user wants to configure a drop-down slicer in Power BI that lets report viewers select different table columns and display those dynamically selected values on a map visual.

How to Add Dynamic Columns to a Power BI Drop-Down Slicer

Product: Microsoft Power BI
Device & OS: not provided
Scenario: Creating an interactive map visual driven by dynamic column selection from a drop-down slicer.
Observed behavior: Power BI slicers do not accept measures directly in the Field setting, preventing straightforward dynamic column swapping on map visuals.

Before you start

Ensure you are using a recent version of Power BI Desktop, as features like Field Parameters are frequently updated. Always back up your current .pbix file before making structural changes to your data model.

Solution 1Recommended

Use Field Parameters for Dynamic Selection

Field Parameters are the built-in, native way to allow users to dynamically change the columns analyzed in a visual without complex DAX.

This feature streamlines the process of switching dimensions or measures, replacing older workarounds that required building disconnected tables and lengthy SWITCH statements.

Enable Field Parameters

Go to File > Options and settings > Options > Preview features, and ensure the 'Field parameters' box is checked (if it is still in preview for your version).

Create a New Parameter

Navigate to the Modeling tab on the ribbon and click on New parameter, then select Fields.

Select the Target Columns

In the dialog box, give your parameter a name (e.g., 'Map Dimension'). Select the geographical or data columns you want users to switch between and click Create.

Apply to Your Visuals

Add the newly generated parameter slicer to your report page. Then, select your map visual and drag the same parameter field into the Location or Bubble Size well.

Use Field Parameters for Dynamic Selection

Seamless Interactivity: Field parameters automatically handle the internal DAX routing, ensuring your map visual updates instantly when a new column is selected from the drop-down.

Solution 2

Seek Specialist Advice in the Power BI Community

For highly complex models where Field Parameters do not apply, specialized DAX patterns involving disconnected tables are required.

Free Microsoft Office alternative

Need a Lightweight Tool for Quick Data Analysis?

While Power BI handles complex interactive maps and massive datasets, WPS Office offers a powerful, free alternative for everyday data analysis. WPS Spreadsheet provides seamless compatibility with Excel formats, intuitive charts, and pivot tables without the heavy resource requirements or steep learning curve of advanced BI tools.

Fully compatible with Microsoft Excel (.xlsx) formatsLightweight and fast for daily data processing tasksBuilt-in pivot tables and charts for quick insightsFamiliar user interface requiring no learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why can't I drag a measure directly into a Power BI slicer?

Power BI slicers are designed to filter data based on static dimension columns, not aggregated measures. To filter or switch visuals based on measures or varying columns, you must use Field Parameters or a disconnected table approach.

What are Field Parameters in Power BI?

Field Parameters are a modeling feature in Power BI that allows users to dynamically change the measures or dimensions being analyzed within a report visual without writing complex DAX code.

How do I use a disconnected table for dynamic slicers?

You create a standalone table containing the names of your columns, use that table in a drop-down slicer, and then write a DAX SWITCH function to calculate and output the corresponding value based on the user's slicer selection.

Can WPS Office create dynamic maps like Power BI?

WPS Spreadsheet supports standard business charting and data visualization but does not have the highly interactive, specialized geospatial mapping capabilities of Microsoft Power BI. It is best used for standard tabular data analysis and traditional charts.

Office Quick Solutions