Is there an easy way for user input?

[rpinxt]

Subject actually is the question.

I have a report and what we would like is the user the put in a Forecast amount somewhere (like a textbox).

This number will be different every day. And the number will be used in a calculation.

And yes we know we can do that in an excel sheet.

But I was wondering if there is a way without adding an extra source.

And a way which is easy for an end user in the pbi services.

[danextian]

Hi @rpinxt 

No matter which slicer type you use, the number entered must exist in the column used for the slicer. You can't input an arbitrary number. To accommodate this, you can create a numeric range parameter table that covers the possible input values.

[rpinxt]

Well that thus means there is no way a user can "store" a number that can be used in a calculation.

So the answer for me would be this is not possible.

[danextian · Accepted solution]

Native slicers do not support this functionality. However, some custom visuals allow writeback, enabling users to input numbers freely, though they can be costly due to the underlying architecture. Additionally, using a slider may not be ideal, as it can become buggy with a large number of values to choose from. Instead, I would add an extra column to the numeric parameter table that converts the Value column to text, allowing the slicer’s search option to be used.

[rpinxt]

Ok thanks. Might be an option if I also can key in the value en it just finds it in the table.

Let me try that out. Think it will be the only solution.

Thanks.

[rpinxt]

No @Deku we can not do this with a parameter I think.

Say the number varies from 15000 to 20000 with increment 1.

That would not be ideal to move your slider to just the exact amount.

Dropwdown of course is also not an option.

And I tried that by setting the slider to single value but then for whatever reason he changes the amount to another amount close to what I entered.

But I need the exact amount I entered.

[Deku]

Maybe try replacing the normal slicer with the new text slicer 

[rpinxt]

That is an interesting sugestion @Deku but I cannot find a way to reference the value that I enter.

If I fill 20000 in the text slicer how would I use that amount in a measure?

[Deku]

You can do this with parameters

It will create a table of values and the value can be selected from a slicer. You can then use the value in a measure