How to Add Parameters in Power BI Report Builder

Tired of building static, one-size-fits-all reports? Power BI Report Builder parameters are your ticket to creating dynamic, interactive reports that let your users slice and dice the data for themselves. This article will walk you through exactly how to add and configure parameters to transform your paginated reports from simple data dumps into valuable, self-service analytical tools.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What Exactly Are Power BI Report Builder Parameters?

Think of parameters as interactive filters that you build directly into your report. Instead of you hard-coding a filter for a specific sales region or date range, a parameter presents a prompt to the person viewing the report, allowing them to choose the values they want to see.

When a user opens the report, they're greeted with simple drop-down menus, text boxes, or calendars where they can make their selections. Common examples include:

• Filtering a sales report by region, country, or specific salesperson.
• Selecting a date range like "Last 30 Days" or a custom start and end date.
• Choosing a product category or SKU to analyze its performance.

The core benefit is that a single report can now serve multiple purposes. Your East Coast sales manager can view their data, while the West Coast manager can view theirs, all using the same report. This saves you an enormous amount of time and empowers your team to find the specific answers they need without requesting a new report for every little question.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Before You Start: Setting Up Your Data

Parameters work by filtering your dataset before the report is rendered. This means your data query needs to be ready to accept a variable. Power BI Report Builder typically connects to a data source using a query language like T-SQL (for SQL Server), DAX (for Power BI datasets), or others.

The most common method involves adding a WHERE clause to your SQL query. This clause is where you'll reference your parameter. When you do this, Report Builder is smart enough to see the variable in your query and will automatically create a report parameter for you.

For example, if you want to filter a sales report by a product category, your SQL query might look like this:

SELECT
    ProductName,
    OrderDate,
    OrderQuantity,
    LineTotal
FROM
    Sales.SalesOrderDetail
WHERE
    ProductCategory = @Category

In this query, @Category is a variable. Report Builder will recognize this and create a parameter named "Category" that will pass the user's selection into this query.

Step-by-Step Guide: How to Add Parameters in Power BI Report Builder

Let’s walk through the process of creating and configuring a parameter. We'll use the example of filtering a sales report by a sales territory.

Step 1: Create a Dataset with a Query Variable

First, you need to set up the dataset that your parameter will filter.

1. In the Report Data pane on the left, right-click the Datasets folder and select Add Dataset....
2. Give your dataset a descriptive name, like "SalesData."
3. Choose your data source.
4. Select the Query text field and enter your SQL query. Make sure it includes a WHERE clause with a parameter variable (prefixed with @).

SELECT 
    SalesPerson,
    OrderDate,
    TotalDue
FROM 
    Sales.SalesOrderHeader
WHERE 
    TerritoryName = @Territory

As soon as you click "OK," Report Builder will automatically detect @Territory and create a corresponding parameter in the Parameters folder.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 2: Configure the Parameter Properties

Now that the parameter exists, you need to configure it to be user-friendly. Find the Parameters folder in your Report Data pane and double-click the newly created Territory parameter to open its properties.

You'll see several tabs on the left. Let’s go through the most important ones.

General Settings

This is where you set the basic look and feel of your parameter.

• Name: This is the internal name Report Builder uses (e.g., Territory). It must match the variable name in your query.
• Prompt: This is the user-facing text label that appears next to the filter control. Make this clear and intuitive, like "Select a Sales Territory:".
• Data type: Choose the type of data the parameter will handle. For our territory name, "Text" is perfect. Other options include Integer, DateTime, Boolean (for true/false), and Float for decimals. Matching the data type to your database column is crucial for performance and accuracy.

Available Values

This tab determines what options the user can choose from. Leaving it set to "None" would give the user a blank text box, which is prone to typos. It's much better to provide a predefined list.

• None: A free-text box. Only use this when the input values are unpredictable.
• Specify values: Manually create a static list. You define a 'Label' (what the user sees) and a 'Value' (what gets passed to the query). This is great for short, fixed lists like "Active" and "Inactive."
• Get values from a query: This is the most powerful and common option. It uses a separate dataset to populate a dropdown list dynamically.

To use "Get values from a query," you first need to create a simple dataset (e.g., named "TerritoryList") with a query that pulls the unique options, like this:

SELECT DISTINCT TerritoryName 
FROM Sales.SalesOrderHeader 
ORDER BY TerritoryName

Then, back in the Territory parameter properties, select:

• Dataset: TerritoryList
• Value field: TerritoryName (the value sent to the query)
• Label field: TerritoryName (the value shown to the user)

Step 3: Default Values

You can pre-select a value when the report first runs to save users a click or show the most common view. Like "Available Values," you can specify a static value or get one from a query. For instance, you could set the default territory to "Northwest."

Step 4: Advanced Settings

Here you can control more specific behaviors:

• Allow multiple values: This one is a game-changer. It turns your dropdown list into a series of checkboxes, letting users select several territories at once. If you enable this, you must update your main dataset query to use an IN operator instead of =.

-- The old query
WHERE TerritoryName = @Territory

-- The updated query for multiple values
WHERE TerritoryName IN (@Territory)

• Allow blank value (""): Lets the user leave the selection blank, which can be useful for optional filters.
• Visibility: You can make a parameter Visible (the default), Hidden (used to pass values behind the scenes, perhaps from another report), or Internal (for internal calculations).

Step 3: Test Your Report

Once you’ve configured everything, click "Run" in the top-left corner. You should now see a prompt at the top of your report with the label "Select a Sales Territory:". Try choosing a different territory from the dropdown list and click "View Report." The data in your report should update instantly based on your selection. Congratulations, you've created an interactive report!

Practical Tips for Better Parameters

Building on the basics, here are a few ways to make your parameters even more effective.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Create Cascading Parameters

Cascading parameters are filters that update based on the selection of another filter. For example, a user selects a Country, and a second parameter for City is automatically filtered to show only the cities within that chosen country.

To do this, the dataset for your second parameter (e.g., "CityList") needs a query that references your first parameter (e.g., @Country).

SELECT DISTINCT City
FROM Sales.Address
WHERE Country = @Country

Just make sure your Country parameter is ordered before the City parameter in the Report Data pane so it runs first.

Use Parameters in Report Titles and Text Boxes

You can make your report titles dynamic by referencing a parameter’s value. Create a text box for your title, right-click it, and select "Expression." Then, enter a formula to combine text with your parameter choice:

="Sales Performance for " & Parameters!Territory.Value

Now, if a user selects "Southwest," the title will automatically change to "Sales Performance for Southwest."

Final Thoughts

Mastering parameters in Power BI Report Builder is a fundamental step toward creating flexible, user-centric reports that deliver real value. You transform a static document into an interactive tool, allowing team members to explore data and answer their own questions without needing technical help.

The goal is always to make data exploration as simple as possible. So, while setting up parameters manually is powerful, we felt the process for connecting and analyzing sales and marketing data could be even easier. Using Graphed, you can connect sources like Google Analytics, Shopify, or Salesforce in a few clicks and automatically build dashboards simply by describing what you want to see. Instead of writing queries and configuring parameters, you just ask a question in plain English, and Graphed creates the interactive charts for you in seconds - all built on live, real-time data.