How to Use the Numeric Range Parameter in Power BI

[anmolmalviya05]

Steps to Create a Numeric Range Parameter in Power BI

Step 1: Create a Numeric Range Parameter

Navigate to Modeling > New Parameter > Numeric Range.

Step 2: Configure the Parameter

A Parameters pop-up box will appear, where you can define the range based on your analysis needs.

Example Configuration:

Minimum: 0

Maximum: 25

Increment: 1

📌 If you set an Increment of 1, the slicer will show every value between 0-25.

📌 If you set an Increment of 5, the slicer will update in steps (e.g., 0%, 5%, 10%, 15%), allowing users to adjust values in a more controlled manner.

After filling in all details, click Create to add the parameter to your report.

Step 3: Create a Measure to Calculate New Profit

Now, we need to create a measure that dynamically calculates the new profit based on the selected discount percentage.

📌 DAX Measure for New Profit Calculation

New Profit = SUM(Sales[Profit]) - (SUM(Sales[Profit]) * ('Discount %'[Discount % Value] / 100))

This measure calculates the profit after applying a discount from the Numeric Range Parameter.

Step 4: Apply the Parameter in a Report

Add the Numeric Range Parameter as a slicer in your report.

Use the New Profit measure in your visuals (e.g., tables or charts).

📌 Example Scenarios:

Without Discount: If the slicer is set to 0%, the profit remains unchanged.

With a 20% Discount: Adjusting the slicer to 20% will instantly show the recalculated profit based on the selected discount.

Final Thoughts

The Numeric Range Parameter in Power BI is a flexible tool that allows users to analyze different scenarios interactively. Whether you want to evaluate discount impacts, sales growth, or financial projections, this feature makes it easier to visualize changes dynamically.

🚀 Try using the Numeric Range Parameter in your reports and enhance your data-driven decision-making!

Let me know if you have any questions! 😊

Regards

Anmol Malviya | Addend Analytics

Proud to be a Microsoft Fabric community super user

Let's Connect on LinkedIn

Subscribe to my YouTube channel for Microsoft Fabric and Power BI updates.