Forum Discussion

lasthero's avatar
lasthero
Frequent Visitor
9 years ago

Removing Page level filter for just 1 visualization

Is there anyway to remove the page level filter for just 1 visualization?

 

For example I have a card visualization that displays the count for November of data i am working with.  The whole page has a page level filter where date >= 11/01/2016 and is < 12/01/2016

 

If i want another card visualization to display the count for October data, how can i do this ?  I basically don't want the page level filter to apply to just this one visualizations..

 

Thanks!

Need Help

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi lasthero,

     

    You can try measurements on these visuals that cancel the filtering done by page or report-level filters, like so:

     

    ID_all = CALCULATE(DISTINCTCOUNTNOBLANK(Table[ID]),ALL(page_filter),ALL(report_filter))

     

    So all the other visuals can use the Table[ID] column, for those that you want to remove filtering, you can use ID_all.

     

    Please mark as solved if you find it useful.

     

    Best,

     

    Leo

    • alienlin's avatar
      alienlin
      Frequent Visitor
      5 years ago

      Thanks, this code works! 🙂 🙂


      ID_all = CALCULATE(DISTINCTCOUNTNOBLANK(Table[ID]),ALL(page_filter),ALL(report_filter))

  • BhaveshPatel's avatar
    BhaveshPatel
    Super User
    9 years ago

    To give you more insights on this, Page level filters are like slicers and you can also edit the interactions between slicers, you can do so by using edit interactions option. 

     

    This will allow you to customize your report as you would like.

    • lasthero's avatar
      lasthero
      Frequent Visitor
      9 years ago

      Hi Bhavesh, 

       

      Thanks for the reply, i understand normally how to edit interactions with the slicer or any other visualizations, however I can't seem to find how do i edit an interaction with a page level filter?

       

      Thanks

      Scott

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Microsoft Employee
        9 years ago

        Hi lasthero,

         

        Page level filter means it filters every visual on the page, and it is not allowed to edit the interaction. To work around your issue, you can add visual level filter or use sclicer to filter the specific visual depend on your need.

         

        Thanks,
        Yuliana Gu

  • th3h0bb5's avatar
    th3h0bb5
    Resolver II
    9 years ago

    Move the visualization to a different page. Page Level filters, by definition, filter everything on the page. Add in another page and put your new visuals there. If you need to see them side-by-side later, you can create a Dashboard view.

  • jondeck24's avatar
    jondeck24
    Advocate II
    9 years ago

    Don't think this is possible as you are applying a page level filter which applies to the whole page.  You could add in a regular date filter and then when its selected go to format/edit interactions and specify which visuals you want that filter to interact with.