How to Create a Dynamic Parameter in Power BI

Tired of building dozens of slightly different charts for every possible question? Power BI's dynamic parameters are the answer, transforming your static reports into interactive dashboards that empower users to explore data on their own terms. This guide will walk you through exactly how to set up and use parameters to make your reports more flexible and insightful.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Are Dynamic Parameters in Power BI?

At its core, a parameter in Power BI is a variable that can hold a value and be used to interact with your data. Think of it as a control knob for your report viewers. Instead of presenting them with a fixed view, you give them a slicer, a button, or a slider that lets them change what they see. This makes your reports cleaner, more engaging, and vastly more useful, as users can answer their own follow-up questions without needing you to create a new version of the report.

There are a few different types of parameters, and we’ll cover the most powerful and common ones:

• Field Parameters: This powerful feature lets users dynamically change the measures or dimensions being displayed in a visual. It's the perfect solution for letting someone switch a chart from "Sales by Region" to "Profit by Product Category" with a single click.
• Numeric Range ("What-If") Parameters: These are ideal for scenario analysis and forecasting. Users can use a slider to input a number - like an assumed growth rate or a discount percentage - and see a calculation update in real time.

Let’s build each of these step-by-step.

How to Use Field Parameters to Swap Measures

Imagine a sales dashboard. You have a dozen important metrics: Total Sales, Profit, Units Sold, Average Order Value, Customer Count, and so on. Creating a separate chart for each one would clutter your report and overwhelm the viewer. The smarter approach is to create one chart and a slicer that lets the user pick which of these metrics to display.

The Goal

We want to create a bar chart that shows a value over time, but we want the user to be able to use a slicer to decide whether that value is "Total Revenue," "Total Profit," or "Orders Count."

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step-by-Step Instructions

1. Find the Field Parameters Feature

First, make sure you have some base measures created in your model. For this example, let's assume we have [Total Revenue], [Total Profit], and [Orders Count] already defined in DAX.

Navigate to the Modeling tab on the Power BI ribbon. Click the New parameter button, and from the dropdown, select Fields.

2. Configure the Parameter

A new window will pop up. This is where you’ll set everything up.

• Name: Give your parameter a clear, user-friendly name. Something like "Select a Metric" or "Choose a KPI" works well. Power BI will use this name to create a new table in your model.
• Fields: This is the most important part. From your data model on the right, find your measures and drag them into the field box. You can add [Total Revenue], [Total Profit], and [Orders Count]. You can even reorder them here or rename how they appear in the slicer by double-clicking them.

Make sure the "Add slicer to this page" box is checked. Power BI will then create the slicer for you automatically. Click Create.

3. Use the New Parameter in a Visual

Power BI has now done two things: it created a new slicer on your report page, and it added a new table (named "Select a Metric" in our case) to your Data pane. This new table contains a column that we will use to control our visuals.

Now, let's connect it to a chart:

1. Create a visual, like a clustered column chart.
2. For the X-axis, drag in a date field, like Date[Month].
3. For the Y-axis, drag in the column from the shiny new parameter table you just created ('Select a Metric'). Do not use your original measures like [Total Revenue].

That's it! Your chart is now linked to the slicer. When a user clicks on "Total Revenue" in the slicer, the chart will display revenue. When they click "Total Profit," the chart will automatically update to show profit — all within the same visual.

How to Use Field Parameters to Swap Dimensions

Now that we've let users change the "what" (the measure), let's empower them to change the "how" (the dimension). This is extremely useful when you want to analyze a single metric from multiple different perspectives.

The Goal

We want to show Total Revenue on a bar chart but let the user decide if they want to see it broken down by product category, by sales territory, or by customer segment.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step-by-Step Instructions

1. Create a New Field Parameter

The process is nearly identical to what we did before. Head back to the Modeling tab > New parameter > Fields.

2. Configure the Dimension Parameter

• Name: Give this parameter an intuitive name, like "View By" or "Analyze By".
• Fields: This time, instead of dragging in measures, drag in the columns (dimensions) you want to analyze by. For example, you might pull in Product[Category], Geography[Country], and Customer[Segment].

Again, make sure "Add slicer to this page" is checked and hit Create.

3. Wire Up Your Visual

Power BI adds another new slicer and another new table to your model.

1. Select the same chart we were using before, or create a new one.
2. For the Y-axis (the value), use a specific measure this time, like our [Total Revenue] measure.
3. For the X-axis (the category), drag in the field from your new dimension parameter table ("View By").

Now you have two slicers controlling one chart! A user can select "Total Profit" from the first slicer and "By Country" from the second slicer, and the chart will update to show profit by country. This unlocks an incredible amount of interactivity and reduces the number of visuals needed to tell a comprehensive story.

Using "What-If" Parameters for Forecasting and Scenario Modeling

So far, we've focused on changing the display of existing data. But "What-If" parameters let you and your users create entirely new scenarios. It's essentially a user-controlled input variable you can use in your formulas — perfect for answering questions like, "What would our projected revenue be if we increase prices by 5%?"

The Goal

We want to build a simple forecasting model where a user can use a slider to select a growth percentage (from 0% to 50%), and a card or chart will show the resulting "Projected Sales".

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step-by-Step Instructions

1. Find the Numeric Range Parameter

Go to the Modeling tab > New parameter > Numeric range. (In older versions, this was called a What-if parameter.)

2. Configure the Numeric Parameter

This opens a configuration window with a few simple options:

• Name: Let's call it "Projected Growth %".
• Data type: Choose "Decimal number" since we want to work with percentages.
• Minimum: 0
• Maximum: Let's set it to 0.5 (representing 50%).
• Increment: Let's use 0.01 for 1% increments.
• Default: We can start with 0.

Again, "Add slicer to the page" is helpful. When you click Create, Power BI adds a new table with two items: a calculated column that generates the series of numbers (GENERATESERIES DAX function) and a measure that captures the value currently selected by the slider.

The measure's DAX will look something like this:

Projected Growth % Value = SELECTEDVALUE('Projected Growth %'[Projected Growth %], 0)

This formula simply returns the value the user has picked on the slider.

3. Use the Parameter in a New Measure

The parameter itself doesn't do a thing. The magic happens when you use its value-capturing measure inside another calculation.

Let's create a new measure for our projected sales:

1. Right-click on your main data table and select New Measure.
2. Enter the following DAX formula:

Projected Sales = [Total Revenue] * (1 + 'Projected Growth %'[Projected Growth % Value])

Here's what it's doing:

• It takes your base [Total Revenue] measure.
• It multiplies it by 1 plus the value from our slider. So if the user selects 0.1 (10%) on the slider, it calculates [Total Revenue] * 1.1.

Pro Tip: To display your slider's value as a percentage, select the slicer on the canvas, go to the Format Visual pane, open "Slicer settings", and check "Show" under the callout value display dropdown. Then, select the value-capturing measure (Projected Growth % Value) in the data pane, and in the "Measure tools" ribbon, change the format to "Percentage."

4. Add to a Report

Now, drag the new [Projected Sales] measure onto a Card visual. Place the new slider on the page. As you move the slider, you'll see the "Projected Sales" number on the card update instantly. You've just built a simple, interactive forecasting tool!

Final Thoughts

Creating dynamic parameters in Power BI is all about moving from a "show-and-tell" report to an interactive analytics experience. By using Field Parameters and Numeric Ranges, you hand control over to your audience, allowing them to slice, dice, model, and explore data in ways that lead to better, faster insights without needing constant report modifications.

Getting your data into one place and setting up these interactions in tools like Power BI is a huge step forward. For many teams, however, the process of report building itself is still a bottleneck. We created Graphed because we believe asking questions about your data should be as easy as having a conversation. Instead of learning DAX and configuring parameters, you can just ask, "Show me a dashboard of Shopify revenue vs. Facebook Ads spend by campaign," and have it built for you in seconds with a real-time data connection.