How to Create a Numeric Range Parameter in Power BI — AI and Power BI — Chapter 7

You will learn how to Create a Numeric Range Parameter in Power BI.

Photo by Rhys Kentish on Unsplash

In any data analysis project, whenever we analyze data, we always want to find out, some what-if scenarios. For example, what if sales increased by 10% or what if we decreased item cost by 1%.

These what-if analyses can be very helpful for any decision-making process.

Power BI has an AI-driven feature that enables us to implement these what-if scenarios. This is known as the Numeric Range Parameter, earlier which was known as the What-If Parameter.

In this blog, we are going to explore this functionality with examples.

Get Data

For this case study, I consider the US Superstore dataset from Kaggle.

• Let’s start with the Get Data option under the Home tab. As this is a CSV file, select the Text/CSV option from the drop-down list
• Select the file named US Superstore data.csv
• After selecting the file, data will be displayed in the below format