Line chart legend to filter custom tooltip

[yamayancha]

Dear Power BI community,

I am working on a project for a client and upon using line charts with custom tooltips (a combination I have not used many times before) I have come across a strange and frankly very annoying behavior and I was wondering if there was a way around it.

I use a line chart of the deviation from a certain average. Takes some computing time but works fine, no issues here. As a legend I use the material table (names of materials have been redacted, you can only see IDs) and I have created a custom tooltip to show additional information (again, mostly redacted but the material ID is the important part).

It seems, however, that the legend of the line chart does not filter the custom tooltip. In the following screenshot you can see me hovering over a datapoint of the material 61130736 but the tooltip is showing a different ID. The measure uses the MAX() function and the issue only crops up if there is more than one datapoint sharing a value on the x axis (= date). So in this case as there are two materials purchased on the same date, both material IDs are passed over to the tooltip and the MAX() function is picking the larger number despite hovering over a datapoint of another material. SELECTEDVALUE() does not work for the same reason: if there is more than one material purchased on the same date then there will be more than one value and the measure would return BLANK.

Is there any way around it? And is this even intended behavior on Power BI's part? I would expect the tooltip to show me exactly what I am hovering over. If I use the regular tooltip I get both values displayed as well.

[Anonymous]

Hi @yamayancha ,

Have you solved your problem? If solved please mark the reply in this post which you think is helpful as a solution to help more others facing the same problem to find a solution quickly, thank you very much!

Best Regards,

Xianda Tang

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

[yamayancha]

I have also added the filtering as an idea, if anyone else is bothered by the way Power BI behaves in this case then please upvote my idea:

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=4ccc0822-3bae-ee11-92bd-6045bd842d0b

Of course it would take time to be implemented so any workaround would still be greatly appreciated!