Forum Discussion
Solution SageIs there an easy way for user input?
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.
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.
8 Replies
- Deku
Super User
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
rpinxtNo 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.
- 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
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.
