cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MichaelH Regular Visitor
Regular Visitor

How to ignore one filter in tooltip but keep all others

Hi Guys,

 

I have a 'current state' snapshot on a front page. I then have a replica of the page as a report page tooltip, but showing the last ten weeks.

In my tooltip, I would like to ignore my 'snapshot week' filter on the main page (to expand from current state to showing previous 10 weeks) but retain all other filter contexts.

 

Can this be done?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: How to ignore one filter in tooltip but keep all others

Hi @MichaelH,

 

Yes, please refer to the snapshot below. You can disable "Keep all filters" and then add the columns that should still work.

How-to-ignore-one-filter-in-tooltip-but-keep-all-others2

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 REPLIES 6
Community Support Team
Community Support Team

Re: How to ignore one filter in tooltip but keep all others

Hi @MichaelH,

 

Yes, maybe you can use a measure to change the context in the Tooltip. Please refer to the snapshot below. The [Measure 8] ignores the context of [BrandName]. If you'd like more details, please provide a demo and the desired result. Please mask the sensitive parts.

How-to-ignore-one-filter-in-tooltip-but-keep-all-others

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MichaelH Regular Visitor
Regular Visitor

Re: How to ignore one filter in tooltip but keep all others

Hmm yes I can do it by creating multiple measures and changing the context in each one, however I have about 15 measures that I would have to do (and maintain).

Is there another way of doing it? 

Community Support Team
Community Support Team

Re: How to ignore one filter in tooltip but keep all others

Hi @MichaelH,

 

Yes, please refer to the snapshot below. You can disable "Keep all filters" and then add the columns that should still work.

How-to-ignore-one-filter-in-tooltip-but-keep-all-others2

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MichaelH Regular Visitor
Regular Visitor

Re: How to ignore one filter in tooltip but keep all others

Thats amazing - exactly what I wanted thank you!

MichaelH Regular Visitor
Regular Visitor

Re: How to ignore one filter in tooltip but keep all others

@v-jiascu-msft this is working really well!

 

One thing - for some reason one slicer selection is being ignored when hovering on the sub-total.

I have it included as you suggested, but it still isn't working!

 

Eg I select Filter1 = A but hovering on subtotal still includes A, B and C

 

Any ideas?

Community Support Team
Community Support Team

Re: How to ignore one filter in tooltip but keep all others

Hi @MichaelH,

 

Did you set the slicer in the Tooltip? If so, I'm afraid it could be how it works. The current context will be passed to the Tooltip when we hover over a visual. 

The workaround could be adding a measure to fix the selections in it.

 

Best Regards,

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