How to add Type in Parameters in Power BI

[Django46]

Hi Users,

I am creating a report in which I have to add  type in parameters so that whenever I input some values in those parameters that Value should get change according to formula applied on that particular parameter. For a simple example I have a dataset with only a single row and the value is 1000, I would like to create a type in parameter so whenever I type any value in that parameter like for example 50 it is, so I want to know how much percentage it is of 1000. I think that will clarify my problem. If not so please ask me! 

Any suggestion or idea are welcome.

[Icey]

Hi @Django46 ,

Is this problem solved?

Best Regards,

Icey

[amitchandak]

@Django46 ,

Not very clear. Most nearest is what if parameter : https://community.powerbi.com/t5/Desktop/What-if-Analysis-in-Power-BI-Multi-layered-Scenario-Buildin...

[Django46]

Sorry, This is not the required feature I am asking. The thing is I want a Type in parameter in which user can input any value and on that value I want to apply certain calculations. so we are trying to create a contract decision Tool that will help us in bringing insights 

so we want a type in parameter like an excel cell where you can type any value.

e.g. Sales =10,000 (From Backend)

 I need a type in where user can enter any number as athe required Rebate%, if he enter 5, then we should be able to calculate Total Rebate as 5% of 10,000. If he enter 99, then it means 99% of 10,000.

[Icey · Accepted solution]

Hi @Django46 ,

Try this:

1. Create a new parameter in Power Query Editor.

2. Keep "Enable load" of Percent Parameter selected.

3. Close and Apply.

4. Create a measure in Power BI Desktop.

Measure = SUM ( 'Table'[Column1] ) * SUM ( 'Percent Parameter'[Percent Parameter] ) / 100

5. Create card visuals.

6. Edit parameters.

For more details, please check the attached PBIX file.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.