Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Remove filter Page from one visual only

Hello guys,    I hope you are well.     Before using a slicer, I was wondering if it was possible to remove a Page filter from only one visual of the page and keeping it for the other visuals ?  ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank for your responses. 

 

I've tried to use All to remove the page filter (month & Partially) it works partially. 

 

Indeed, on my report I use a month page filter. I removed the Page filter in my dax formula by using the ALL like this : 

 

= CALCULATE(Sales ,ALL('Date Table'[Month and Year])).
 
Thanks to this, the chart shows the sales for all the months for each year but I would like to filter showing only the last 6 months. I've tried this to check the logic : 
 
=
CALCULATE([Sales],
ALL('Date Table'[Month and Year]), FILTER('Date Table', DATESBETWEEN('Date Table'[Date],DATE(2019,11,1),TODAY())))
 
But it didn't work. Do you have an idea to solve this issue ? 
 
Many thanks for your help, 
 
mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi Anonymous ,

 

try this.

 

=
CALCULATE (
    [Sales],
    ALL ( 'Date Table'[Month and Year] ),
    DATESBETWEEN ( 'Date Table'[Date], DATE ( 2019, 11, 1 ), TODAY () )
)