Selected page level filters and slicers are not passed to custom tooltip

[charles_g]

Hi,

I have a bar chart and I would like the tooltip to inherit the slicers and filters set at the page level.

This works correctly if I switch on "Keep all filters" on the tooltip page.

However, I don't want to pass all the filters set at the visual level, therefore I turn off the option "Keep all filters" and I drag the filters that I want to keep individually.

But in this case, the tooltip doesn't keep any slicer or filter. It only takes the context set by the axis and legend of the bar graph.

Is this the expected behabior? It seems strange that I can either keep the full filter context including slicers, page level and visual level filters, or only the context set by the dimensions of the visual.

Am I missing something?

Thanks for any help

[v-henryk-mstf]

Hi @charles_g ,

It is not yet clear what you need, can you provide the relevant screenshot description and test data, so that I can solve it for you as soon as possible.

How to Get Your Question Answered Quickly - Microsoft Power BI Community

Looking forward to your reply.

Best Regards,
Henry

[charles_g]

Hi @v-henryk-mstf, 

Have you had the chance to look at the new details I posted or do you need more information?

Many thanks,

Charles

[charles_g]

Hi Henri,

Thank you for your reply.

Here's a very simple model for demonstration.

If I select Keep all filters on the tooltip page, it works as expected.

But if I select individual filters to keep. It only keeps the filter on the month, which is the context set by the visual itself. It ignores the filters applied on Name. 

The expected value is 2460 when only the filters on Month and Name are applied.

Link to the PBIX:

https://1drv.ms/u/s!AsL1_x1q-_NMg4IXiXDB4TgG7RYR2g?e=Q6vukA

[v-henryk-mstf]

Hi @charles_g ,

Although it is not clear how the 2460 was calculated. If you want to keep the filter conditions for the Month field and Name field, you can modify the following formula.

Total amount = 
CALCULATE (
    SUM ( Transactions[Amount] ),
    ALLEXCEPT ( Names, Names[Name] ),
    ALLEXCEPT ( Dates, Dates[Month] )
)

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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

[charles_g · Accepted solution]

Thank you for your reply @v-henryk-mstf ,

Unfortunately, your solution doesn't work, but it helped me find a workaround that requires to use a different measure in the tooltip.

To clarify, here is what I get if I set Keep all filters on the tooltip page:

But I want to set a different filter on Place in the tooltip while keeping the filters on Month and Name from the bar chart. Here's what I want to get and expected when I selected the Month and Name filters on the tooltip page:

 

My workaround is to select Keep all filters and use a different measure in the tooltip to replace the filter on Place, as follows:

Total Amount new =

CALCULATE(

SUM(Transactions[Amount]),

Places[Place] = "Rome"

)

And here's the result:

The tooltip keeps the filter on Place from the chart but it is replaced in the measure.

I'm still puzzled by the behavior of the filter inheritance in the tooltip and I'm surprised that this requires a woraround.

I must be missing something.

(The figures are different from my previous post and from your post because I used a random function in DAX to generate the data)

[v-henryk-mstf]

Hi @charles_g ,

It is not yet clear what you need, can you provide the relevant screenshot description and test data, so that I can solve it for you as soon as possible.

How to Get Your Question Answered Quickly - Microsoft Power BI Community

Looking forward to your reply.

Best Regards,
Henry