How to user written value from a text slicer without a fixed range

[Anonymous]

Hi Team,

I have one filter in my report which accept hardcoded input from a user in existing other platform then Power BI, it return the same what user as pass in the O/P. How to achieve same in Power BI. Basically passing this user input will go to query and it will return result.

For Example: Here I selected -1, then O/P will contains -1, if selected 100 then 100.

Input

O/P

[Anonymous]

Hi @Anonymous ,

Please check if what-if parameter can achieve your requirement, you can refer the following links to do it.

Power BI Quick Tips: What if Parameters - YouTube

Getting Started With The "What If" Parameter In Power BI | Enterprise DNA

Best Regards