Forum Discussion
Power BI Input Measure for Budget amount
Hello All,
Does power bi has feature to input value from user entry and disply data in Deck visual.?
In my instance finance users would like to input different budget amount in power bi report so remaining calculations can be written /driven based of input budget amount.?
Thanks
vs
- Anonymous2 years ago
Hi, refint650
You can refer to ExcelMonke reply, use the What-if parameter to fulfill your requirement, please note that this feature does not support user input of arbitrary values, which is a caveat.Official document:
Use parameters to visualize variables - Power BI | Microsoft LearnBest Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
2 Replies
- AnonymousNot applicable
Hi, refint650
You can refer to ExcelMonke reply, use the What-if parameter to fulfill your requirement, please note that this feature does not support user input of arbitrary values, which is a caveat.Official document:
Use parameters to visualize variables - Power BI | Microsoft LearnBest Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
- ExcelMonke
Impactful Individual
Yes, you can use a parameter to complete what you are trying to achieve. One thing to note is that you sort of have to predefine what kind of numbers the end-user can enter (i.e. Max and Min values, etc.)
Then you can create measures that use the value within the parameter to calculate whatever you want to calculate.