Multiple slicer dependency

[Uhrond]

HI,

I am facing the following issue: I have a first slicer that allows me to choose between 'weekly' and 'monthly', and a second slicer that contains end-of-week or end-of-month dates.

If I select a weekly date, for example 17/05/2024, I get the data.

If I change my slicer to 'Monthly', the date 17/05/2024 remains selected and no data is displayed (I don't have monthly data for 17/05/2024).

You must understand that you need to select a different date in the list to retrieve the Monthly data.

Thank you for your help

[Alex87 · Accepted solution]

Ok, so, my proposition for you is to use bookmarks:

1. Add your Date slicer to the page and go to View/Bookmarks / Add . Make sure no selection is done to the slicer and create the bookmark "Month" with the following settings (data checked)

2. Add another bookmark called "Hebdomadaire" this time make sure the Data is not checked

3. Insert/Buttons/Navigator/Bookmark Navigator with FORMAT grid layout vertical

Now every time you click Hebdomadaire you can select a date and the value in your card will adapt but when you select month, the filter will be cleared.

If it answers you query, please mark my reply as the solution

[Uhrond]

Thanks for your solution, it works well !

[Uhrond]

This is not very user-friendly as a functioning, you have to guess which slicer is blocking the data.

Is it possible to always select in the slicers one of the values that exists in the context of the other filters or to deselect everything.

In my example, we would need to deselect the 17/05 as soon as we switch to monthly.

[Alex87]

so what is the issue? it looks like a normal behavior. Please tell us your expectations and provide data so that we can reproduce your use case. Thanks