How to add a slicer that filters 2 other slicers

[pedroccamaraDBI]

Hi guys

I have 2 fact tables to filter. Both of them has a column named Category.
I have a report that shows me all sales by month for a specific category which is in a slicer.
In the same report, i have all purchases by month for a specific category which is in another slicer.
Both category slicers has the same values.
How can i have just one slicer that filters both visual, sales and purchases?
Thanks in advance
Pedro

[v-zhangti]

Hi, @pedroccamaraDBI 

Can you provide some of the example data? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures.

Best Regards

[amitchandak · Accepted solution]

@pedroccamaraDBI , I think you need to have two slicers and one of them needs to be independent.

refer

Compare two Brands: https://youtu.be/exN4nTewgbc

Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE

[pedroccamaraDBI]

Very good @amitchandak 
Thank you so much