Reset Child Slicer (Technology) When Parent Slicer (Market) Changes

[muhammad_pathan]

Background info

I have two slicers: Market and Technology. The Technology slicer is dependent on the selected Market.

market is a country such as Germany abd the available technologies are:

Solar

Storage

Wind Offshore

Wind Onshore

In this case, "Wind" (as a general category) is not needed, because Germany reports wind data specifically as Wind Offshore and Wind Onshore.However, in markets like the United Kingdom, wind data is reported simply as Wind, without splitting it into Offshore and Onshore categories.This variation occurs across several markets. For instance, Solar data may be unavailable for some countries like Great Britain and Sweden.Therefore, I want the Technology slicer to dynamically update based on the selected market, showing only the technologies that have available data.

I have this working in a dax query the issue am having is due to "sticky slicers" so for example if i select Germany with Wind Onshore. then i switch to United Kingdom it shows Wind Onshore as an option if you switch the category then go back on there is no Wind Onshore category. so it happens due to being pre saved from change. Is there any way to have it default to a value there or a way to stop this 'ghost' behavior

is there any way to update second slicer based on set

Germany (below available tech)

Solar
Storage
Wind Onshore
Wind Offshore

United Kingdom (below available tech)
Storage
Wind

e.g. user clicks country the second slicer dynamically updates to these options only

first image is when user click on a country that has variable that is not present in another e.g (Germany)

Second image is what happens when you switch to a country where that technology is not available

Third Image is when you click o a technology that is available then go on dropdown again

Things i have tried 

https://exceleratorbi.com.au/slicer-values-dont-clear-after-changing-a-second-slicer/

[v-echaithra]

Hi @muhammad_pathan ,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,
Chaithra.

[lbendlin]

That is a design limitation.  You cannot programmatically clear out filter choices made by a user. One of the reasons why default filters and RLS do not work well together, for example.

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com

[muhammad_pathan]

so theres nothing i can do about this. Is there any workarounds e.g using bookmarks to make it look as if its cleared?

[v-echaithra · Accepted solution]

Hi @muhammad_pathan ,

Here is an Bookmark based workaround while keeping a manual reset button.

Setup your both Market and Technology Slicers.

Now create a view for bookmark.

Clear the Technology slicer, click on the slicer > press the eraser icon in the top right to clear selection.
Go to View > Bookmarks Pane.
Click “Add” to create a bookmark, rename it to something like reset_technology.
With the button selected, go to Action > Type: Bookmark.
Choose the bookmark reset_Technology.
As tt’s a manual action, user has to click the reset button.

Best Regards,
Chaithra.