Display different value on hover

[#1]

Hello,

I have a scatter chart where I have plotted Product IDs. However, when you hover over the points, I would like to have the Product Description display, rather than the Product IDs. I have to plot IDs over Descriptions because the relationship is not 1-1.

Any ideas on how to do this?

Thank you,

Mel

[jpenuliar]

You can try adding another expression  " ='Product Description : ' & [Product Description] " and tick Text as Pop-up

[jpenuliar]

Keep in mind, the third expression dictates the bubble size, so you would want to add it after that

[jpenuliar]

You can also add Product Description as first Dimension

[MarcoWedel · Accepted solution]

Hi,

another solution could be a calculated dimension that generates dual values (Product ID (if numerical) formated as Product description):

=Dual([Product Description],[Product ID])

Using the Product description directly as the first dimension would require it to e unique like the Procuct ID.

Otherwise the bubble count and positions could change.

hope this helps

regards

Marco