Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
78 | |
75 | |
50 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |