Forum Discussion

Gchandrukris's avatar
Gchandrukris
Icon for Helper I rankHelper I
6 years ago

Slicer filter not working

Hi, 

Your help is much appreciated on the below! Thanks in advance.

I have 2 slicer for category and subcategory. If i select category in slicer 1 then corresponding subcategory should display in slicer 2. 

 

If select the cat1 in slicer 1 then corresponding subcategory/Value appear in the slicer 2. But if select the cat2 in the slicer 1 then slicer 2 should display only values belong to cat2 rather it display cat2 value + previously selected value.

 

Please refer the attachment

Need Help
Show and Tell

2 Replies

  • v-alq-msft's avatar
    v-alq-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi, Gchandrukris 

     

    Based on my tests, It is the issue about selectable values and selected values of a slicer. Actually, slicer selectable values change with context, but selected values can't change automatically. When you make 'C11' selected and then make 'CAT2' selected , the selected 'C11' will still exists because it can't change automatically. However, the selectable values are changed as 'CAT2' and the corresponding values appear in the list. I think it is a normal phenomenon.

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.