Date Slicer Dependent on Year Slicer

[oliverblane]

I have a table "DateTable" that looks like the following:

Note that the Fiscal Year is running from April 1st to March 31st in this case.

I have a single select slicer for the "Fiscal Year" column, and I would like that slicer to influence the selection of a slicer on the "Date" column. It should look like this - when a Fiscal Year is selected, the range of the dates on the Date slicer should default to the start and end of that Fiscal Year (e.g. in this case 1st April 2021 - 31st March 2022):

Is there any way to achieve this, perhaps with the use of Measures?

Here is a sample PBIX file: sample.pbix

Many thanks!

[DataInsights · Accepted solution]

@oliverblane,

Go to Format --> Edit interactions, click on the Contract Year slicer, and click the chart icon on the Date slicer: