String as input in whatif parameters

[anil]

Hi All,

           We are trying to create a user form in power bi report. So users can enter data to the field values. We are able to create numeric input parameter but unable to create string based input parameter. The intention is to create string parameters so users can enter Account Name, Project ID and Creation date, so these details will be added to the report table. Then extract it as csv files.

Is this possible in Power Bi? Need help.

Above image, in has two input boxes need to enter project id and creation date so the same reflects in the below table.

Sample pbix file: https://www.dropbox.com/s/9u4nyhq2oa3y5pj/Input%20Test.pbix?dl=0

[WendyXue]

5 years on, it seems string values are still not allowed in parameters? It's really useful when user need to filter report using a combination of keywords.

Text filter and Attribute slider do not support that complexity.

PowerBI app seemed a bit overkill, a textbox for user to input string and store the value in parameter would be super efficient. 

[v-juanli-msft]

Hi @anil

What if parameter is not suitable for imputing string to the table.

It only supports to input data of type number

In your scenario, create a new table containing Account Name, Add the column of this new table into a slicer so that you can select which Account Name  to display. the same for Project ID and Creation date.

Best Regards

Maggie

[anil]

Thanks for the reply Maggie,

  But we cannot create a table as the input should be dynamic by the user. Another way to do it is using powerapps, but with powerapps we need to write back to database and show the input data in the power bi table.

Looking for an alternate solution within power bi to input text.

[v-juanli-msft]

Hi @anil

Based on researching, there is no such function to input string to power bi.

You may submit an idea here.

Best Regards

Maggie