Forum Discussion
How to create an input object and a variable?
I need to make available in a dashboard where there is the possibility of the user imputing information and this information will interact with a measure and that finally this measurement will be displayed in graphical, for example:
I have a measure where I present the value of the sales target for that year based on what was sold in the previous year, for example, 2016 was sold 1 million and the target for 2017 is 1.5 sales, in this case an increment Of 50%, but this increment is not a fixed value and who determines this is the user, today he wants to apply a goal of 50% tomorrow he may want to apply a goal of 10%, and to be doing it in the database is not feasible .
Is there any object in power bi where the user can enter the information and that information be stored in a variable and that variable be used in a measure?
Anonymous
Its seems you have a Secondary Y-Axis for the line (its on the right side of the chart in the second picture you posted)
You have to turn it off if you want the line to stay above!
11 Replies
Currently there's no way to truly get user input.
There's an Idea about it though
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9414921-input-fields
You can kind of simulate this with a parameter table and Slicers but it will not be really user input (more like user choice)
EDIT: Okay I found the link to my previous post showing the paramter table option...
https://community.powerbi.com/t5/Desktop/Dynamic-Increase/m-p/37122#U37122
Okay, I figured I did not have this feature even if I do with the filter features as an employee? Would I apply the filter field with the percentage in measure?
I believe I would have to create a field with the possible percentages the user would use.
Seems What if Parameters can solve this problem relatively cleanly if folks are still looking for a solution (as I was).
The alternative way I'm usign is "What if parameter"+ "Measurement".
Below is my example: User manually input currency rate(USD- Taiwan Dollor), and the USD list price will be changed accordinly.
https://docs.microsoft.com/en-us/power-bi/desktop-what-if
