Selections on slicers

[#1]

Hi,

i have a requirement like this->

have 3 slicers :Location, category,Product.

I have kept these in multi boxes so that the user can select an option from the drop down .

if the user selcts a location then only the related categories should be displayed in the category drop down.

similarly for the product based on the category.

How do i do that.

Please help.

Thanks in advance.

[amars]

You can put a expression like this

If(GetSelectedCount(location)=1, categories)

U can use an expression like that

instead of using the fields

[amars]

You can also use the hide excluded option in the properties so that unrelated Categories will not be shown.