Slicer question

Thank you for your answer. I am quite aware of the sync slicer feature; however, I think I was unclear with my question. Let me elaborate.

On page 1, I have:

a) Date slicer

b) Location slicer

Both the date slicer and location slicer slice my fact table.

I am also using the following DAX measure:

This, I have set as a visual level filter on the location slicer to only show items when DAX evaluates to 1.

The intention is:

1. User slices date
2. Date slices fact table
3. Location slicer only displays locations where facts exist during the sliced date
4. Location slicer can be used to slice fact table based on existing locations for the given date frame

This all works well on page 1.

On page 2:

• Location slicer - synced.
• However, I do not want to have a date slicer on page 2.

On page 2, what I want to happen is:

• Fact table is NOT filtered by date.
• Fact table should be filtered by location/locations. The locations to choose from should only be those within the sliced date frame from page one.

This is not happening. So the synced slicer is not really synced now.

Example:

For example, I have sales in Stockholm, Vienna, London, Berlin, Munich.

Let's say for Stockholm, there are only sales made in 2024. For the rest of the locations, there are sales every year.

Page one:

On page one, there will only be a map displaying locations where sales have been made, one date slicer, one location slicer.

A user goes into page one and decides to slice the date to include 2020-2023.

Location slicer is now updated thanks to the DAX measure, which will now only display the options: Vienna, London, Berlin, Munich - excluding Stockholm.

Page 2: Graphs

The graphs should now display data from sales in Vienna, London, Berlin, Munich and exclude Stockholm, BUT also include 2024.

Now, Stockholm does exist even though the location slicer is synced on the pages, and page 1 has a date set to 2020-2023.

Does this clarify what I am trying to achieve?