Creating Dependent Filters of Last 12 Months filter and Date selection Filter

[Anonymous]

Hello Data Geeks,

I have some issues regarding customize interactions between Last 12 Months Filter and Date Filter in the report. I have created a Last 12 Month filter to filter all visuals based on last 12 months dates period only and date filter for custom date selection for the users as shown below. Image 1 shows the filters set.

Image 2 showing that if Last 12 M filter is selected then date filter is disabled and only last 12 months are getting filtered which is correctly working.

However in Image 3, if user selects particular date and then if Last 12 month filter is selected then it's not working correctly as date period is not getting filtered for last 12 months and in fact dates selected by user are not getting override by last 12 month filter. Here the dates were filtered initially from Dec 2023 to Aug 2024 however after selecting Last 12 M filter the dates range doesn't changed where it should be changed to Sep 2023 to Aug 2024.

So need a good guidance to achieve this in all possible ways and Thanks in advance.

Image 1
Image 1

Image 2

Image 2

Image 3 

Image 3

[Anonymous]

Hi @Anonymous ,

Can't seem to open this link, is there another way you can share this demo?

Best regards,

Adamk Kong

[Anonymous]

Hello @Anonymous ,

This link is accessible for anyone.

Try this once...

https://drive.google.com/file/d/1d3TMFCBi4_1j8AKXCEF6ZaAz7qQvLRrA/view?usp=sharing

Or check out below the folder link please...

https://drive.google.com/drive/folders/186Yfqlf1myN7e38wCBLfPRlJdRoKHU4C?usp=sharing

[elitesmitpatel]

Hey @Anonymous 
please share the dummy data in PBIX file for easy reference and it will be time saving for us.
Thank you

[Anonymous]

Hello @elitesmitpatel ,

Thanks for your message.

Please refer the below link to access the pbix file dummy data.

https://drive.google.com/file/d/1d3TMFCBi4_1j8AKXCEF6ZaAz7qQvLRrA/view?usp=sharing