Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 Axis Titles
What I mean is that whenever I select different parameters from the filters, the chart titles/axis titles should update accordingly. This can be based on a Concatenate function. Do we have something similar as Tableau here where I can simply concatenate a few static words with dynamic words from the filter? I have looked at a few solutions which suggest using ConcatenateX but that does not work with the Direct Query mode. Please help!!
Solved! Go to Solution.
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
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
Thank you Jimmy this works!
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |