How to set Preset filter on comparisons line chart?

[ravi_raval]

I have created a comparison line chart report to show previous date data on my line chart. now I want to set the preset filter on this line chart how can I do it? I want to add preset filter values like Yesterday, last 7 days, Last 30 days, Last 3 months, Last 6 Months, Last 1 Year, etc. Below is the SC of my created report for your reference.

Please help me to set this values on my report.
Thank You.
Ravi Raval

[ravi_raval]

Thank you for your quick response

Yes, It's working for me but I want to set the preset filter as per the below screenshot.

is it possible for the same?

[PijushRoy]

Hi @ravi_raval 

What is the criteria for Custom date
Also client may ask you for more dropdown in future

So it is always better to convey this message and make the dynamic slicer as I shared in my last comment.

Alternative way, you can filter the data and create as Bookmark for all 5 option. Then use the bookmark as Button in report.

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

[ravi_raval]

So How can give a custom date range in this filter? 

[PijushRoy · Accepted solution]

Hi @ravi_raval 

You can use filter when going to save the bookmark in filter pane

If your requirement is solved, please mark THIS ANSWER as SOLUTION

[PijushRoy]

Hi @ravi_raval 

In slicer, use date field and enable Relative Date option
where user can enter any number of date and use the filter

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