Forum Discussion
Custom Tooltip not showing correct values
Hi,
I have created a custom tooltip for a map that shows information about each company including its name, zip, city and sales.
When I pull the company name field into a text field on the custom tooltip, it returns the first company with the zip code rather than the company that was responsilbe for the sale. However, when I add zip, city and sales fields, they all work correctly.
Any suggestion on how I could fix it? Thanks!
Anonymous I think the way you laid out your tooltip is not a good approach. If you hover over one data point on the point, and there are multiple companies, you will not see the correct value on the tooltip. You need to put all the columns in a table/matrix visual, if one data point on the map has one company this approach would have worked.
Make sense?
7 Replies
Anonymous tooltip uses the aggregtion, if you using a text column directly on tooltip, in this case company name, it will give you first (aggregation) name of the company, you can change it to last etc but you cannot list all companies.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
parry2kThanks for explanation. Is there an alternative to using the text column? I tried writing a measure, but I cannot work out how to get the measure to return a company name.
Anonymous can you share your sample data and what you are trying to achieve. If it is a multiple values for a text column, you have to concatenate to create a long string and use that as a tooltip or create a custom tooltip and show a list of all the text values in a table format. I hope it makes sense.
Anonymous , tooltip is always at the same level as axis/group by; that is why you have aggregation.
Try is this can help : https://docs.microsoft.com/en-us/power-bi/desktop-tooltips
