Slicer release when use other slicer

[michaleczuszek]

Dears, 

I have two slicers (filters). One is for Calenrar year 2020 and 2019 and other is for Fiscal year 2021 and 2020. 

Is it possiblt to have 'formula' which release all filtering in one filter when other is in use. 

Example 

I pick Calendar year 2020 in first slicer. Then i  want to go to second slicer and pick Fiscal year 2021 (which contacins different data). So if i am going to pick Fiscal Year 2021 from second slicer, first slicer will release all filtering automaticaly. 

Thanks 

[Greg_Deckler]

@michaleczuszek - Yes, you could use SELECTEDVALUE or other means to determine if something is selected in one slicer or the other and then probably use ALL to remove the other filter context and apply the appropriate filter context. But, details will depend on your specific data, table relationships, etc.

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.