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 ? 

 

Many thanks for your help, 

 

Need Help

9 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Anonymous 

    great question, but I do not any option like this without programming

  • 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 () )
)