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.
Published in
4 min readSep 13, 2021
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