Power BI reports can quickly become cumbersome when multiple pages and visuals are needed to show every possible combination of data. Field and numeric range parameters provide a way to simplify reports while giving users more control over what they see. With parameters, you can allow users to customize report visuals, switch between different measures, and even perform basic calculations without exporting the data to Excel.

Simplifying reports with field parameters

Consider a sales report that breaks down orders, products, and revenue across locations, salespeople, and products. Creating separate tables and pages for every combination provides the necessary information, but navigating through all those visuals can be inefficient. Field parameters let you consolidate those views. Instead of assigning a fixed field to the rows of a matrix, you can create a field parameter containing options such as:

• Location
• Salesperson
• Product

Add the parameter to the matrix rows and create a slicer for it. Users can then select how they want the data grouped directly from the report. Selecting Product displays the breakdown by product. Selecting Salesperson changes the same visual to a salesperson breakdown. Users can also select multiple fields to create additional levels, such as viewing each location broken down by salesperson.

Using field parameters for columns

The same approach works with columns. For example, a matrix containing sales information might originally use Year and Quarter as its columns. You can create a column field parameter containing options such as:

• Year
• Quarter
• Location
• Salesperson
• Product

Users can then dynamically choose which dimensions appear across the columns of the matrix. Multiple selections can also be combined. For example, users could view orders by year and location, then drill down further to see products within those categories. This makes it possible to answer different questions using a single visual instead of maintaining separate tables and report pages.

Switching between measures

Field parameters are not limited to dimensions. They can also contain measures. For example, you can create a Values parameter containing:

• Revenue
• Number of orders
• Product sales volume

After adding this parameter to the Values area of a visual, users can switch between these measures with a slicer. The same report could therefore display product sales by location and year as revenue, order count, or sales volume without requiring separate visuals for each measure.

Using parameters with charts

Field parameters also work with charts. A parameter used for matrix rows can be assigned to a chart's legend or other appropriate field. The same slicers can then dynamically control how the chart displays information. Depending on the visual, allowing multiple selections may produce unwanted results. In those situations, configure the slicer to allow only a single selection. This keeps users from selecting field combinations that do not work well with the visual.

Creating numeric range parameters

Numeric parameters work differently from field parameters. Instead of allowing users to choose fields or measures, they generate a range of numbers that can be used in calculations. To create one, go to the Modeling tab, select New Parameter, and choose Numeric Range. You can specify:

• The data type
• Minimum value
• Maximum value
• Increment

For example, you could create a decimal parameter ranging from 0 to 1.1 in increments of 0.01. The resulting parameter can be displayed as a slider and used as a percentage in calculations.

Building an interactive sales goal calculator

Numeric parameters can be useful for basic business planning. Suppose you want to establish next year's sales goals using the average sales from the previous three years plus a percentage increase. First, create a measure that calculates the average annual sales for each salesperson. Then create a sales goal measure that applies the percentage selected through the numeric parameter. The slider allows users to adjust the percentage and immediately recalculate the sales goals. For example, increasing the parameter changes each salesperson's target without requiring you to rewrite the measure or export the information to Excel. This turns the Power BI report into a simple interactive planning tool.

Creating more advanced calculators

Numeric parameters can also be combined to create more sophisticated calculations. For example, multiple parameters and measures can be used to build a basic compound interest calculator. Users could adjust values such as:

• Principal
• Interest rate
• Number of months

The measures can then calculate the resulting interest based on those selections. While a compound interest calculator may not be necessary for every Power BI report, it demonstrates how multiple numeric parameters can work together to provide additional flexibility and interactive analysis.

Why use Power BI parameters?

Field parameters give end users control over the structure of report visuals. They can swap fields and measures in and out of tables and charts to focus on the information that matters most to them. Numeric parameters provide another level of interaction by allowing users to adjust values used in calculations. Together, these tools can help you:

• Reduce unnecessary report pages and duplicate visuals.
• Let users choose how data is grouped and displayed.
• Allow users to switch between different business measures.
• Create interactive calculations and planning tools.
• Perform simple what-if analysis directly in Power BI.
• Reduce the need to export data to Excel for basic calculations.

By combining field and numeric parameters, you can build Power BI reports that are more compact, flexible, and responsive to the needs of different users.