Apply specific filter to a card

[PBI5851]

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])))

[v-xicai]

Hi @PBI5851 ,

You may use "Edit interactions" feature to choose which visuals to be filtered by one special visual, follow steps below.

Reference:

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions .

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Tahreem24]

Refer the below links for edit interaction:

https://radacad.com/control-the-interaction-in-power-bi-report

[collinq]

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!

[Anonymous · Accepted solution]

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,