Forum Discussion

PBI5851's avatar
PBI5851
Icon for Helper V rankHelper V
6 years ago
Solved

Apply specific filter to a card

I have a card that gives a number based on my query. On the page, i have two slicers, a Date slicer and a Category Slicer.  Is it possible to change the Card value based on just the Category Slicer and not change , if the Date slicer were to be updated. 

 

The formula for the Card i have is 

Current Size = CALCULATE(COUNTA(Product[productID]),filter(Product,Product[PurDate]=MAXA(Product[PurDate])))
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Yes there is. 

     

    In the desktop version go to "format" in the menu, then click on edit interactions.  You can then turn off visual from filtering each other (a slicer is of course a visual).

     

    So you click on the slicer, and then turn off the interaction on the visual you want.

     

    Thanks,

     

     

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Yes there is. 

     

    In the desktop version go to "format" in the menu, then click on edit interactions.  You can then turn off visual from filtering each other (a slicer is of course a visual).

     

    So you click on the slicer, and then turn off the interaction on the visual you want.

     

    Thanks,

     

     

  • collinq's avatar
    collinq
    Icon for Super User rankSuper User
    6 years ago

    Hi PBI5851 ,

     

    In Desktop, you can use the Edit Interactions function to turn on/off which slicers and which visuals interact with each other.

     

    I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!