Forum Discussion

salmanmohammad's avatar
salmanmohammad
Frequent Visitor
8 years ago
Solved

Dynamic Chart Titles in Direct Query Mode

Hello all,   I am creating a dashboard using an SQL server in the Direct Query mode. I would like to achieve the following based on slicer/filter selections:   1. Dynamic Chart Titles 2. Dynamic...
Need Help
Tips and Tricks
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi salmanmohammad,

     

    Yes, concatenatex() is not supported in direct query mode. You can simply use & operator to concatenate the exist column and the result of selectedvalue().

     

    Regards,

    Jimmy Tao

     

     

v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi salmanmohammad,

 

Yes, concatenatex() is not supported in direct query mode. You can simply use & operator to concatenate the exist column and the result of selectedvalue().

 

Regards,

Jimmy Tao

 

 

salmanmohammad's avatar
salmanmohammad
Frequent Visitor
8 years ago

Thank you Jimmy this works!