Forum Discussion
Dropdown slicer value does not change when a value is selected in another dropdown slicer Dropdown s
Hi,
Thank you in advance.
I have two dropdown slicers, one has a Product category and other has Sub category. When I change a value in Product category slicer, my selected value in Sub category does not change. Only when I open the dropdown of sub category and change the available the slicer value changes.
Can we have a default value selected or all values selected when we change a value in another slicer?
Please see below screenshots for your reference.
Table :
Before changing a value in Product category slicer :
After selecting another value in Category slicer :
Default expected selection in Sub category :
Please help.
Thanks
7 Replies
- SpartaBI
Community Champion
you can create a measure like: COUNTROWS(Table) > 0, put it in the visual level filters of the subcategory slicer and set it so that only 1 is selected in the filter
let me explain, i face issue when i change a value in products slicer. Example : when I change from category 2 to catogory 1 my available values should only show category 1 sub categories. But it is showing category 1 and 2 sub categories which is incorrect.
- SpartaBI
adnan1 I understood in the beginning 😃.
I gave you the solution for that 😆
BTW, if your 2 columns are coming from the same table this should work by default like you want.
Could it be that you changed the settings in the filter interaction between the two of them so that the sub category slicer will not be affected by the Category slicer?
mahenkj2Solution Sage
- mahenkj2
In fact, Once I select A in sub category, my category filter automatically restricted with 1 only till I first make clear selection of sub category. becuase they are from the same table. Certainly there is some interaction setting which is affecting this behavior. You try to find that, else just post a reference file with dummy data.
