How to ignore one filter in tooltip but keep all others

[Anonymous]

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?

[wzkoral]

Can I disable just some filters not all ?? Ps. can I choose filter to ignore ??

[v-jiascu-msft]

Hi @Anonymous,

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.

Best Regards,
Dale

[Anonymous]

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? 

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

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

Best Regards,
Dale

[Anonymous]

@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?

[v-jiascu-msft]

Hi @Anonymous,

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,

[Martine10]

Hi @v-jiascu-msft ,

I had the same problem and tried to turn "keep all filters" off on the tooltip page and dragged all necesary filters and slicers from the original page in the box below ti. However, this does not seem to have any effect. It seems like all the filters are ignored. What do you mean with "Did you set the slicer in the tooltip?". And could you explain more about your suggested workaround with a measure?
Thank you, Martine

[Rahul_SC]

Hi,

I am having the same issue. this solution does not work. Can anyone help here, please ?

[Anonymous]

Thats amazing - exactly what I wanted thank you!