Dynamic tooltip using filtered measures.

[Anonymous]

Hi,

I have a report with 10+ Line charts. Where every line chart shows one line with values from a filtered dimension called Test.

For each line chart I have created a measure as below, filtering on Test1, Test2, Test3 etc instead of having a filter on every visual.

Avg. Test1 =
CALCULATE(
AVERAGE(Fact[TransformValue]),
KEEPFILTERS('Dimension'[Parameter] = "Test1"))

The problem I am facing with the approach of having one measure for each visual is when showing the Tooltip which will show every value we have instead of the filtered value in my measure, which is logical.  But I want to be able to use one Tooltip instead of creating several Tooltips, each having the correct measure in them.

The tooltip is a straight table with columns like below.

When I have a filter on the visual and use same Measure on each visual I can use the same Tooltip which will be filtered on the Test1 value for example.

My question is: Is there a way to filter the tooltip with the measures in some way? Making one Tooltip reusable and dynamic.

Thanks in advance 🙂

[danextian]

Hi @Anonymous 

You will need to convert you measures into a pseudo-column by  either

1. using calculation group (that explicitly indicates a measure instead of SELECTEDMEASURE)
2. or a disconnected table that holds the measure names and another measure to return the desired value
3. or by using field parameters

Please see attached sample pbix.

Note: if you intend to have all the measures in one line chart and dynamically change the tooltip  based on what's currently hovered, that is not currenlty possible. When you hover a line chart, what is hovered is the x-axis category and not each y-axis element.

[Anonymous]

Thank you for your reply and explanation danextian.

I have looked into the pbix and what I would like to have is a filter on each category in the ToolTip and the visual. So one visual should be on Category "Apparel" and the other one on Category "Cosmetics".

And this without having to use a filter on the visual as in the picture.
Do you think this is something that can work?

Thank you!

Previ