Set date range on selecting specific fiscal year while also be able to select date outside the range

[Chaithra_Kushal]

I have a date table with Fiscal year(Nov - Oct) and Date. I have a report with these two slicers, when selecting a Fiscal year, I would like the date range to be set to Nov - Oct while also be able to select a date from outside the range. Currently, I am able to set the date range to that specific fiscal year using edit interactions. But, the rest of the months are disabled.
Thanks in advance.

[Chaithra_Kushal]

Fiscal year 2023: Range is Nov 2022-Oct 2023(default)
Which i am able to implement.

But unable to pick a date from outside the range. How can I achieve this?

[PijushRoy · Accepted solution]

Hi @Chaithra_Kushal 

If you select date range outside the year 2023, therefore your page will show Year as 2023 but other visual will show data for 2022 or 2023 or 2024. I think this will be very confusing information for business users.

To achieve your requirement, you should turn off the interaction between Year and Date slicer. Please note, default date range will not work that time.

Or use only date slicer

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[PijushRoy]

Hi @Chaithra_Kushal 

Can you please share screenshot of the current state and expected result