Forum Discussion
user input
There is no way for a user to input arbitrary values when interacting with a published report. If you have a limited set of values you'd like to be able to pick between, you could supply those values in a custom table and use a slicer to allow users to select a value. But if you want users to be able to type in anything they want you're out of luck.
thank you vary much,it was very helpful.
the client want 2 values (0,1), but he want to determine where (on the report) does it still possibale?
I'm sure it is, but it's not quite clear how you want to use them. You'd have to create a dummy table containing those values, assign that column to a slicer, then write a measure that uses the slicer selection.
Measure = SUM(Tablename[ColumnName]) * MIN(UserInputTable[VariableColumn])
...or something like that. MIN, MAX, AVERAGE, SUM, FIRSTNONBLANK, all should work the same if there will always be only one slicer selection.