user input

[yuval86]

Hello everybody, I'm a beginner user of Power BI.. I have a question about Power BI and I will be pleased if someone here will help me, do you know if (and how) can I insert "user input" to the Dashboard?

my client want to be able to change value on existing column, does it possible?

the solution can even be in Java,R ,C#..

Thank you very much!

[mork]

I doubt this is possible. But someone more experienced than me will probably give you a better answer.

[yuval86]

thank you anyway!

[KHorseman · Accepted solution]

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.

[yuval86]

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? 

[KHorseman]

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.