Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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
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?
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
So How can give a custom date range in this filter?
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
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
User | Count |
---|---|
90 | |
84 | |
65 | |
62 | |
58 |
User | Count |
---|---|
147 | |
113 | |
95 | |
81 | |
71 |