How to Add Parameters in Power BI Dashboard

Transforming a static report into an interactive, dynamic dashboard is one of the most powerful things you can do in Power BI. Adding parameters is a game-changer for this, letting you build “what-if” scenarios and give users control over the data they see. This guide will walk you through exactly what parameters are and how to create and use them in your dashboards step by step.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What Exactly Is a Parameter in Power BI?

Think of a parameter as a live, user-controlled variable inside your report. It’s like a dimmer switch for your data, you can slide it up or down to change values and see the results update in real-time. Instead of building five different visuals to show five different sales forecasts, you can build one visual and add a parameter that lets the user explore all five forecasts - and everything in between - with a simple slider.

The most common and useful type is the “What If” parameter. This lets you create a slider (or input field) on your dashboard that feeds a number directly into your calculations. For example, you could add a "Sales Commission (%)" slider that your team can adjust to see how different commission rates would impact total forecasted payouts. It moves your report from being a historical record to a tool for future planning.

Why Bother With Parameters? The Big Benefits

While parameters might seem a little technical at first, the payoff is huge. Here’s why they are worth adding to your skills arsenal:

• Create Engaging "What-If" Analyses: This is the headline benefit. Parameters are the backbone of scenario planning. You can easily model outcomes for questions like, “What would our revenue have been if we had increased prices by 10%?” or “How many more leads do we need to hit our sales target if our conversion rate drops by 2%?”
• Improve Dashboard Interactivity: Giving your end-users control makes them more engaged. Instead of being passive viewers, they can interact with the data to answer their own questions. This empowerment gets your dashboards used more frequently and effectively.
• Reduce Reporting Clutter: You no longer need separate charts or report pages for every single scenario. One well-designed A/B comparison chart with a parameter can replace a dozen static visuals, making your dashboard cleaner and easier to understand.
• Dynamically Filter or Segment Data: Beyond forecasting, parameters can be used to dynamically show the “Top 5” or “Top 10” performing products, filter data based on changing thresholds, or change which metric a visual is displaying entirely.

Graphed

Still Building Reports Manually?

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

Watch the Demo

How to Create a "What If" Parameter: Your Step-by-Step Guide

The best way to learn is by doing. Let's create a "What If" parameter to model a hypothetical price increase on sales revenue. For this example, imagine you have a sales table in Power BI with a measure called Total Revenue.

Our goal is to create a slider that lets us see what the total revenue would be if prices increased by a certain percentage, from 0% to 50%.

Step 1: Locate the New Parameter Option

Open your Power BI Desktop file. In the main ribbon at the top of the screen, click on the Modeling tab. Here, you'll see an option called New Parameter.

Note: If you click the dropdown, you might see "Numeric range" and "Fields." For our purposes, "Numeric range" is the default for a "What If" parameter.

Step 2: Configure Your Parameter's Settings

Clicking New Parameter will open a configuration window. This is where you'll define how your parameter looks and behaves. Here's a breakdown of each setting:

• Name: Give your parameter a clear, descriptive name. This will become the title of the parameter and the name of the table Power BI creates. Let's name it “Price Increase %”.
• Data type: Choose the type of number you need. Since we're working with percentages, Decimal number is the best fit. If you were modeling something like headcount, you might choose "Whole number."
• Minimum & Maximum: Set the lower and upper bounds of your slider. For our price increase model, we'll set the Minimum to 0 (for a 0% increase) and the Maximum to 0.50 (representing a 50% increase).
• Increment: This defines the steps the slider will jump with each move. An increment of 0.01 will allow users to adjust the percentage by single digits (1%, 2%, 3%, etc.).
• Default: Set the starting value for the slider when a user first opens the report. Setting it to 0 makes sense here.

Finally, make sure the box for Add slicer to this page is checked. This handy option automatically adds a slider for your new parameter directly onto your current report page, saving you a step.

Step 3: See What Power BI Created

Once you click "OK," two things happen instantly:

1. A new slicer appears on your dashboard. You can now see and interact with your "Price Increase %" slider.
2. A new table appears in your Data pane on the right. Power BI automatically generated a new calculated table named "Price Increase %".

If you look at this new table, you'll see it contains two things:

• A calculated column, also named "Price Increase %," which contains a list of all possible values from your min to max at the increment you specified (0, 0.01, 0.02, ... 0.50).
• A DAX measure named “Price Increase % Value”, which is defined as:

Price Increase % Value = SELECTEDVALUE('Price Increase %'[Price Increase %], 0)

This measure intelligently captures the single value currently selected on your slicer.

Don't worry about modifying this generated table. The important takeaway is that your new measure, Price Increase % Value, is how you’ll reference the slider's current position in your own formulas.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Putting Your Parameter to Work: The Real Magic

You have a slider, but right now, it isn't connected to any of your data. Moving it doesn't change anything in your visuals. The next step is to create a new measure that uses the parameter’s value to calculate a "what-if" result.

We need to create a Projected Revenue measure that takes our existing Total Revenue and multiplies it by our "Price Increase %" parameter.

Step 1: Create a New Measure

In the Data pane, right-click on your main data table (the one containing your Total Revenue measure) and select New Measure.

Step 2: Write the DAX Formula

When the formula bar appears at the top, type the following DAX formula. It’s simpler than it looks!

Projected Revenue = [Total Revenue] * (1 + 'Price Increase %'[Price Increase % Value])

Let's break down this formula:

• Projected Revenue =: This is just the name we’re giving our new measure.
• [Total Revenue]: This is your existing measure that calculates the current revenue. Always use existing base measures where possible.
• (1 + 'Price Increase %'[Price Increase % Value]): This is where the magic happens.

Press Enter to save your new measure.

Step 3: Visualize the Result

Now, let’s see the payoff. Add your original Total Revenue and new Projected Revenue measures into visuals on your dashboard. A 'Cards' visual is great for this side-by-side comparison.

Drag the Total Revenue measure to a card visual. Then drag your new Projected Revenue measure to a second card visual right next to the first one.

You're all set! Now, go to your "Price Increase %" slicer and start moving it. As you do, you'll see the Projected Revenue card update instantly. Slide it to 10%, and your number goes up. Slide it back to zero, and the two cards will match perfectly. You have successfully built your first what-if analysis in Power BI!

Graphed

Still Building Reports Manually?

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

Watch the Demo

Additional Tips & Next Steps

Once you are comfortable with “What If” parameters, you can begin unlocking their deeper use cases:

Use a Parameter for Top/Bottom Filtering

Imagine letting your audience decide if they want to see your top 5, 10, or 20 salespeople. Create an integer-based “What If” parameter for N and incorporate that using a TOPN DAX expression to filter a table.

Dynamically Change Dimensions On a Chart

What if your axes could update on your PowerBI reports? Using Field params, create a parameter that can toggle the chart to show sales by Region, by Salesperson, or by Product Category using a simple slicer to make the selection. While Fields are set up slightly differently from a "What If" numeric range, they allow your team more robust levels of control when exploring information. Making dynamic dimension toggles is a surefire way to impress your stakeholders when building Power BI Reports.

Final Thoughts

Using parameters takes your Power BI reports from static documents to interactive analytical tools. By following these steps, you can set up powerful 'What If' scenarios that allow your team to forecast, explore possibilities, and make better-informed decisions directly within your dashboards.

The learning curve for tools like Power BI can be intimidating, especially when you have to start writing DAX formulas just to ask a simple forecasting question. To simplify things for teams who just need answers, we built Graphed. Instead of navigating menus and writing formulas, you can connect your data sources and simply ask for what you need, like, “Forecast our revenue if Facebook Ads spend increases by 15%.” Our AI builds the interactive analysis for you in seconds, saving you time and frustration.