Forum Discussion
How to create an input object and a variable?
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!
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.
Thanks for the link, I am trying to apply something similar in power bi, but it is not working as expected, would you have some example of this link applied in power bi?
Anonymous
To see an example go to the bottom of the page at the above link where it says Downloads
Download the Excel 2013 zip files - extract all
Then Open PBI - File - Import - Excel Workbook Contents - Select ParametersTable - Multiple - Excel 2013.xlsx - Open
click Start on the warning "We don't work directly with Excel... blah blah..." - Copy Data - Migration Completed - Close
Save the File as pbix - you may have to close and open it again
Now create a Matrix - place Product in the Rows and SalesAmount and DiscountedSalesAmount in the Values (Sales table)
then create a Slicer with the field from the Discounts table - select any value from the slicer and see how the Measure reacts!
Hope this helps! :smileyhappy: