Override Slicer Filter with a Filter in My Measure

[myri]

Hello,

I have a special situation where I have a graph that is being filtered by a slicer. This slicer is filtering column A (let's say). Naturally, that slicer is also filtering the custom tooltip I have for that graph. I would like to override/ignore the slicer filter in my tooltip and instead apply a filter on same column (column A) in my measure that I'm displaying in my tooltip. Which is where my problem lies, because if I use the all function, it ignores the filter instead the measure as well.

Any help appreciated!

[v-luwang-msft]

Hi @myri ,

You can edit interactions with slicers and other filtering elements per-visual. Select a visual and open the Format tab in the ribbon. Turn on Edit Interactions and you can turn off interaction with the slicer in question.

There is no way to make a measure ignore a particular slicer. You can make it ignore a column, but it's messy and it will ignore that column everywhere it is referenced, whether it's in a slicer or some other filter. The closest way I know of is to use ALLEXCEPT, which is used to specify every column from that table that you don't want the measure to ignore.

Wish it is helpful for you!

Best Regards

Lucien

[myri]

Hi Lucien, thank you for the answer, but that would not work for me. I still need the contents of the graph to be filtered with the slicer. It would be like lets say I had a country slicer filtering a graph, and I showed sales of Germany in the graph. I would want to show the UK sales in the tooltip, so I would need to void the slicer filter and apply my own in the tooltip. Does that make sense?