Forum Discussion
User input in desktop
Main question being, is it possible in powerbi to have a parameter or other form of user input that can set a variable for a row?
If you mean create Var% column dynamically based on user input, you can create what if paramater in Power BI Desktop, then create a measure named Var%.
Var% = Parameter[Parameter Value]*MAX(Table1[Var])
Then you can crate the following measures.
Include/Exclude = IF([Var%]>2, "No", IF([Var%]<0.5, "Yes",BLANK()))
NewStd = IF([Include/Exclude]="Yes" ||ISBLANK([Include/Exclude]),MAX(Table1[ActualHours]),MAX(Table1[StandardHours]))
Regards,
Lydia
Hi Lydia,
The user needs to decide whether or not to include or exclude, it is not based on a formula,
Thanks
aucklanduser,
Please elaborate that what variable the users would input, and what result would you like to get based the input based on above sample data.
Regards,
LydiaHi Lydia,
The user will input either include or exclude (1 or 0) to include or exclude the row from the calculation based on the cost accountants judgement
aucklanduser,
If the Include/Exclude column is a existing field or a calculated column in your table, you can create a slicer using this field for user to choose.
Otherwise, you can create what if parameter(1 or 0) as my previous reply. If you still have questions, please post expected result based on the above sample table, and elaborate more about your desired result following the guide in the blog below.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Regards,
Lydia