Forum Discussion

jimmymitra's avatar
jimmymitra
Advocate I
8 years ago

Dynamically change slicer value based on selection in another slicer

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 t...
Need Help
quentin_vigne's avatar
quentin_vigne
Solution Sage
8 years ago

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's avatar
jimmymitra
Advocate I
8 years ago

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.