Create a variable text input on a sheet

[dmmanchon]

Good, how can you add to a sheet an "input" of text and then use it in DAX formulas?

A greeting

[v-gizhi-msft]

Hi,

I think maybe you want to try something like What If parameter, see this link:

https://docs.microsoft.com/en-us/power-bi/desktop-what-if 

Best Regards,

Giotto

[dmmanchon]

It could be, but I need it to be text. And as I've seen the what if only supports numeric parameters, right?

[v-gizhi-msft]

Hi,

If you have restrict all the text values and there are not too many text values, you can manually generate a table by DATATABLE function.

Then you can use this table's field as a slicer for users to select and add this vairable to DAX formula.

Best Regards,

Giotto

[Greg_Deckler]

Not certain what you are looking to do exactly. You could create a table and use a slicer. Otherwise if you want adhoc text input the only way to do that really is by using the PowerApps visual.

[dmmanchon]

Hey, Greg, could you recommend some visuals?