Forum Discussion
Using measure to set a dynamic title
Hi all,
I am having an issue setting dynamic titles using a measure.
I have made a calculation "total commission QTD" and now I want to display this measure in the tile of my line chart.
In order to add it, I had found online that I needed to format this calculation. So here you have my current title measure:
Title total commission QTD = FORMAT([total commission QTD], "€#,###, K")
Now, I don't understand why this measure can't be used as my dynamic title. When I try to set this up and select the measure, here you see my result:
In the first dropdown, there is also only one option (veldwaarde = fieldvalue in dutch).
I have also tried to use a measure that doesn't have any calculations in it like the following one:
Title test = "testing"
But here I have the same issue.
I found this approach initially via this tutorial: https://www.youtube.com/watch?v=qumRCVLjcIo
Hope you guys can help me! Thanks in advance.
Anton
In the attached file it works, if you work with direct query format function is not supported , so i think that this is a reason.
please refer to the linked discussion:If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
11 Replies
- Ritaf1983
Super User
Hi AntonV
It is very challenging to understand what is going wrong without seeing exactly what you are doing.I've just recorded my screens and saved the PBIX file; please follow along with me
Link to media fileIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
- AntonV
Helper I
Hi Ritaf1983 ,
I looked at your video and it looks like we do the exact same thing.
To be sure, I have recorded my screen as well: https://www.loom.com/share/d96400928b944ac4b6d64e50e5cdeb6f?sid=27edc3d7-13a9-4545-9fdd-71ec3d9ba358
Do you have any idea what could be different? Is there a setting that I should change to allow dynamic titles? (I have never used this before...)