Dynamically change slicer value based on selection in another slicer

[jimmymitra]

Hi All,

We have two slicers in the report as “Countries” and “CurrencyCode” by which we filter the sales data.

Requirement is after selecting multiple countries ( from "Countries" slicer), if the total number of distinct currency codes is greater than 2(e.g. EUR, INR and DKK), then we should show a default value in the “CurrencyCode” slicer (say “EUR”) else it will show two or less number of currency codes in the “CurrencyCode” slicer.

Could you please help me with the DAX or any setting in the power BI report to achieve this?

Thanks for your help in advance.

[quentin_vigne]

Hi @jimmymitra

You can add interaction between two slicers.

If it's not working at the moment, you can enable filter in both directions when editing relations between table, it should work !

Down below you can see it in French but it will look exactly the same in english it is where it's writed "A double sens"

Hope this will help

[jimmymitra]

Hi @quentin_vigne,

Thank you for your kind reply. But my situation is a bit different. Sorry for not making it clear in the first time.

The second slicer "CurrenyCode" is currently getting filtered by the first slicer("Countries") selection. But I want to tweak the value shown in the "CurrencyCode" slicer i.e. if the number of distinct count of currency code ( after selection of "Countries" slicer) is greater than 2 then we need to show a default value ( say "EUR") in the CurrencyCode slicer instead of all the values . In case the currencycode count is eqaul or less than 2 then this values remain the same.

Thanks.