Dropdown slicer value does not change when a value is selected in another dropdown slicer Dropdown s

[adnan1]

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

[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.

[mahenkj2]

Hello @adnan1 ,

Below links may be of help:

https://prathy.com/2019/02/sync-slicers-sync-slicers-advanced-options/

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=po...

[adnan1]

Hi @mahenkj2 ,

Thanks for your reply. The link you provided is very informative, it shows syncing of two slicers having same columns in two slicers, but I am interested to sync two different columns in two different slicers. Is there a work arround for this?

[adnan1]

@SpartaBI i created the suggested measure but cannot figure out how do I set the visual level filter = 1 using this measure? can you please guide here?

To answer your questions yes I have the settings between the two slicers such that sub category will not affect category slicer.

Much Thanks.

[SpartaBI]

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

[adnan1]

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?