How to filter a slicer based on other slicers

[bmms]

Hello everybody,

I am not able to filter a slicer based on other slicers.

In my example, I have the year and month slicers (calendar table) where I show a summary of sales by product and by seller.

Then I have a details section where I intend to filter the dates by a date range. (for examplo from 12/12/2022 to 13/12/2022)

To select the date range, I have a slicer based on sales dates (sales table), but I can't get this slicer to only select dates from the year and month that was previously selected.

For example, you can see in the following image that I have selected the year 2022 and month 12, and the date slicer lets me select dates from November!

How can I solve this problem?

You can download my example using the follow link:

https://we.tl/t-BotCaXkL9U

Best regards.

[Anonymous · Accepted solution]

Hi @bmms ,

I downloaded your .pbix file, I found that you turned off the interaction of the slicer, you can use "Edit interaction" to open the slicer interaction, you can achieve your needs:

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution  to help the other members find it more quickly.