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
mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi Anonymous ,

that is currently not possible.

The filters follow a kind of inheritance hierarchy that cannot currently be interrupted. 

Unless in a DAX calculation.

 

Filter on all pages > Filter on this page > Filter on this visual

 

  • 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 () )
)
    • v-chuncz-msft's avatar
      v-chuncz-msft
      Community Support
      6 years ago

      Anonymous 

       

      You may also try measure below.

      Measure =
CALCULATE (
    [Sales],
    ALL ( 'Date Table'[Month and Year] ),
    FILTER (
        ALL ( 'Date Table'[Date] ),
        DATEDIFF ( 'Date Table'[Date], TODAY (), MONTH ) < 6
    )
)

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hello, 

         

        Thank for your help. 

         

        Unfortunately, both formulas don't work properly as you can see below. The results is same for all the period and it's not the last 6 months.

         

         

        I don't understand where is the issue because when I do : 

         

        CALCULATE([% Sales],
ALL('Date Table'[Month and Year]))

         

         

        I have the correct results but not in the period I I want as you can see below  : 

         

         

        Do you have idea where could be the issue ? 

         

        Many thanks for your help,