Single visual on a report page that isn't filtered by 'Filters on all pages'

[Anonymous]

Hi all, 

I have a report in which I typically limit things by quarter, but I wondered if it would be possible to provide a visual that ignores the filters set by the report - and provides feedback on all history.

e.g. selection is Q1 2021, but this visual provides an oversight of the history of a particular aspect of the report - so provides the past few years as summary? 

Is it possible without having to set individual filters on each page/visual? 

Thanks! 

[selimovd]

Hey @Anonymous ,

you can use a measure and use the ALL modifier:

All Time Sales = CALCULATE( SUM( myTable[Sales] ) , ALL( dateTable[date] ) )

This ignores the date filters.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

Thanks - I'll play around with that, but the idea would be that it ignored the date filters and providing feedback for a wide range (so instead of just Q1, it would provide Q1, 2, 3 & 4 from the past year) - so it would need to be more than just the total figures for each, but the dates that went with them to help demonstrate patterns? 

[Pragati11]

Hi @Anonymous ,

You can use edit interactions on this visual of your's to limit change when a filter/slicer selection is done on the report.

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

Thanks,

Pragati

[Greg_Deckler]

@Anonymous Try using the ALL function in a measure to override filter context and include everything.

[Anonymous · Accepted solution]

Thanks - I've figured a way of avoiding the date filter by creating a dummy table and linking them, now I just need to do the same for the values part of the visual. 

[v-yiruan-msft]

Hi @Anonymous ,

Whether your problem has been resolved? Do you need any else help regarding this thread? If the problem still not be resolved, you can refer the method in the following threads to get it.

Ignore page level filter in Measure

How to exclude one visual from page filters?

Allow a single visual to ignore report level filters

Best Regards