Custom Tooltip not showing correct values

[Anonymous]

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!

[amitchandak]

@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

[parry2k]

@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.⚡

[Anonymous]

@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.

[parry2k]

@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]

This is the custom tool tip I created:

And that's fill the fields:

Company Info:  Name field from table with all client companies

ZIP: ZIP field from table with all client companies

City: City field from table with all client companies

Sales Info: SUM(Sales) form sales table

[parry2k · Accepted solution]

@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? 

[Anonymous]

Makes perfect sense. Thanks @parry2k