dynamic text box in live connection

[powerbityro]

hi all,

is it possible to create a dynamic text box in a live connection. i want something like "Report and so on 2. Quarter 2019" where 2. and 2019 is dynamic. In live connection i have not the FORMAT command.

many thanks.

[v-yuta-msft]

@powerbityro ,

You can create a measure using dax below:

Result =
"Report and so on " & [Column1] & ". Quarter " & [Column2]

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[powerbityro]

hi it works when i use a simple measure/column like [Column1] but not when i have something like IF( [Column1]>0; "positive";"negativ")

[v-yuta-msft · Accepted solution]

@powerbityro ,

So that's the limitation in live connection mode.

Regards,

Jimmy Tao