Updating tooltip in a hierarchy column

[amir_mm]

Hi,

Is there a way to update the default tooltip when using a hierarchy column?

The X-axis is a hierarchy column with multiple levels. For example, when we drill down to "City" and hover over a bar, the default tooltip shows "Canada Toronto." However, it needs to be separated—for example, displayed as "Canada < Toronto."

I tried creating a concatenated calculated column and adding it as a tooltip, but the default formatting remains unchanged, displaying the first line by default.

Thanks!

[Anonymous]

Hi @amir_mm 

This post hasn't been updated in some time, so I'm here to follow up. May I ask if this problem has been resolved? If speedramps' reply helped you, please consider accepting his reply as a solution.

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[speedramps · Accepted solution]

Download my example PBIX solution from OneDrive

Click here 

Create custom DAX measue.

The ISFILTERED will supress the > when viewing at the Country level 

Custom = 
SELECTEDVALUE(yourdata[Country]) 
&
IF(ISFILTERED(yourdata[City]),
" > "
&
SELECTEDVALUE(yourdata[City]))

Create a  new report page.

And set the canvas settings to Tooktip or Custom to make to page very small.
Rename the name if required

Add cards or a multi-row card with the Customer measure and the required total

Remove card label, unless required

Go back yo your graph page, clcick on the graph visaual and in format menu set the Tooltips to the above page

Test it

We are unpaid volunteers and you have got free expert help which took a lot of effort.
This solution works and does exactly what you asked.
So please quickly click the [accept as solution] and the thumbs up button to leave kudos.
If you need to change or extend your request then please raise a new ticket.
One question per ticket please !
You will get a quicker response and each volunteer solver will get the kudos they deserve.

If you quote @speedramps in your next tickets then I will then receive an automatic notification, and will be delighted to help you again.

However I will respectfully decline to help members twice who ask misleading or incomplete questions and then dont accept the correct soltion. Hope you apprecaite why.

Please now click the [accept as solution] and the thumbs up button. Thank you