Title Based on Name Of Used Measure

[vojtechsima]

Hello, 
I have a strange request, but I believe it's very interesting.

I want to dynamically change the title of a visual depending on which measure that visual is using.

For Example this visual use this measure:

The visual title would be like this:

I played with some DAX functions but can't figure it out.

Thank you 

[v-luwang-msft]

Hi @vojtechsima ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[parry2k · Accepted solution]

@vojtechsima only solution would be if you have a predefined measure and then you select in the slicer what you want to show and that can be used to create the title as well. In this case, the calculation group will make it super easy but again it will only work if the list of measures is predefined and user can select using the slicer.

I will stay away from the SWITCH function although it will do the job, one core reason is that if the measure has a different format, you cannot do that using SWITCH  and this can easily achieve with calculation groups. I have tons of videos on various calculation group use cases, if interested, check out these videos here https://youtube.com/playlist?list=PLiYSIjh4cEx2s8-jXBhv5aCu5_6F9zQ3I

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

[AntonioM]

If it's a set few measures you want to swap between, you could create a column with the titles and use a SWITCH to select each one.

Then set the title to First Measures, or you could make a title measure = SELECTEDVALUE(Measures[Measure])

This might also be something that Calculation groups can do better. You have functions such as SELECTEDMEASURE and

SELECTEDMEASURENAME which might be able to get the name of the current measure (they're not something I've ever used).

[vojtechsima]

Hi, @AntonioM 
Thank you, yeah exactly, that was might first thought but I wanted to go all the way into dynamic execution.
The calculation groups might do the trick, thanks for the suggestions, haven'T yet played with it but seems like good opportunity.

If nobody will post that solution I will post it here when I will get to it.

Thank you for suggestions, @AntonioM