Forum Discussion

powerbityro's avatar
powerbityro
Icon for Helper II rankHelper II
7 years ago
Solved

dynamic text box in live connection

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.

Need Help

3 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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's avatar
      powerbityro
      Icon for Helper II rankHelper II
      6 years ago

      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's avatar
        v-yuta-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        powerbityro ,

         

        So that's the limitation in live connection mode.

         

        Regards,

        Jimmy Tao