Hello,
I’m trying to get a dynamic title to work with a calculation group where the calculation item name will change based off of the selection I make in a slicer.
In this case, I’d want it to say Money Ticket in the title. If I clicked on Opportunity %, I’d want it to say Opportunity % in the title.
I tried using this method, but wasn’t able to make it work the way I expected.
I first created a disconnected table with Metric 4 (this is the name of the calculation group in the slicer)
I then created this measure based on the blog post’s example:
Rank Chart Title =
VAR _MEASURE = CALCULATE(
COALESCE(
[HVAC Service Opportunity %],
[HVAC Service Money Service Orders Filtered],
[Turnover Set %],
[HVAC AOR Run Service Orders],
[HVAC AOR Close %],
[Average Sale (sales)],
[Average Ticket (run)],
[HVAC Service Completed Revenue],
[Sales Service Orders],
[HVAC AOR Sales],
[HVAC AOR Installs Revenue]
),
TREATAS( VALUES( 'Test Table'[Measure] ), 'Metric 4'[Name] )
)
RETURN _MEASURE
After that I created the title:
Rank Chart Title copy =
SELECTEDVALUE('Test Table'[Measure])
But when I use this measure as the title it gives me the numeric value and not the name of the calculation group item name
Any thoughts on how to solve this would be appreciated!
@Everett could you please try a workaround from our EDNA video? Thanks
2 Likes
Hello @Everett,
Did the responses above help solve your query?
If not, can you let us know where you’re stuck and what additional assistance you need?
If it did, please mark the answer as the SOLUTION by clicking the three dots beside Reply and then tick the check box beside SOLUTION
Thank you
Hi @Everett
We’ve noticed that no response was received from you on the post above.
Just following up if you still require assistance to solve your inquiry.
In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.
I saw this video before posting and it doesn’t solve the issue unfortunately. Calculation groups are finnicky, so it’s hard to get them to act as expected with normal measures. I’m still in the process of figuring out a workaround.
Thank you for the suggestion though.
@Everett Is it possible to share the PBIX?
1 Like
Unfortunately no, but I did find a work around which I’m planning on posting soon.
1 Like
Thank you, @Everett, for providing the information. We greatly appreciate your willingness to share your solution on this post.
I’ll be closing this thread. To share your solution, kindly remove the Solution tag. To do so, click the three dots beside the Reply button and uncheck the corresponding checkbox.
Once you have shared your solution, please mark your reply as the solution to this thread.
We sincerely thank you for your valuable contribution to our community.
Solution:
So the issue when trying to make a dynamic title when you have a calculation group is that it’ll only return the value of the calculation group instead of the actual title.
To get around this, you have to use the calculation group’s Name column that’s created when you created the calculation group itself. I just wanted the title to appear and not any kind of slicer or button. So I decided to use the Card visual, but when you do that you aren’t allowed to add the Name field from the calculation group. The trick is to create a slicer visual first, add the Name column, and then switch the visual to a Card visual.
I then doctor up the cards so that they look close to a title. So now you have dynamic title for calculation groups 
