Dynamic Values in Text Box Aren't Working for Parameter Values in Custom Tooltip

[heatherkw]

I'm pretty sure this is fairly simple and I'm just missing one piece of the puzzle. I have been asked to move away from the usual tooltip to make custom tooltips that put the information into a sentence structure. Right now, I have one bar graph that has a parameter where users can select various client demographics.

I have a textbox on a tooltip page that I am using dynamic values with to create the sentence. I need the sentence to read like this: "For clients with a Race of Native Hawaiian or Pacific Islander, the average was XX" when the user hovers over the bar for Native Hawaiian or Pacific Islander and then if they hover over the bar for Black or African American, the underlined portion changes to that. Then, if they select a different demographic such as Gender, it would change to say, "For clients with a Gender of Female, the average was XX" when users hover over the bar for Female. I can get the text to change for the field itself, so Gender/Race, etc., but can't get the actual value to display based on which bar they hover over in the graph. I could have sworn that I figured something out like this before, but for the life of me I can't seem to recreate it and have a quick deadline.  

[Anonymous]

Hi @heatherkw,

AFAIK, the mouse hover event is specific filter that can't be traced by filter functions. It can be responded when you use formula with correspond filter on the report tooltip page.

What happens if you use the measure formula on the card visual in the report tooltip page? Did this dynamic changes in tooltip when you hover the mouse?

If that is the case, it means this feat not compatibility with text box dynamic values features. You can submit an idea for this requirement.

Regards,

Xiaoxin Sheng

[heatherkw]

Hi there, I'm not sure what the measure formula should be. I can't seem to figure out any way to return the value that I want in the text box itself so the hover feature therefore doesn't work. 

[heatherkw]

That doesn't take into account the dynamic text needed for the Parameter, that's the big issue. If they select Race, then it needs to say a Race of XX, then if they change to Gender, the text needs to say a Gender of XX. I can get the Parameter name to change, so Race, Gender, etc., but the value chosen is the issue. 

[vicky_]

If you have a measure with text for the tooltip, you can try something like:

TooltipText = "For clients with a Race of " &  SELECTEDVALUE([Race]) & ", the average was " & [Measure]

+ make sure that the keep filters is on for the tooltip.