Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi there,
Thank you in advance.
I have a slicer which has the 'between' option and it has the last 30 days date range where users can pick any dates from the last 30 days. Its refreshing every day so the date range is always the 30 days. Name of the column is 'deliverydate' for the slicer. I also use the same column for my chart as an x-axis. and there is price value on the y-axis. Chart is also filtered with another market slicer. So 'market' is on the legend on the chart.
My question is; How can I set the slicers date as a default displaying the last 2 days but at the same time user will option to change the dates. (when user first open the report, the slicer will be the last 2 days as a default and the chart will display the last 2 days data. But user will be able to change the dates. )
With the 'Relative Date' option I can set the dates for the last 2 days but it won't let the user to pick a different date to change the date range. (It will only display the last 2 days.)
I am pretty sure it would be with a dax but couldn't figure. Thank you
Are you dead set on using the date range slicer?
This is probably more of a work around - I personally would probably acheive this by creating an input parameter (such as # days), creating a measure that feeds in that variable, and setting it to default to 2 days, but allowing them to select anything between 1 and 30 days.
Does that make any sense?
However, if you are set on it needing to be a date range filter, sorry I'm not sure how to help!
Thank you @DemingPDCA. I appreciate your suggestion. Client wanted to be a slicer with the between option actually like a date range filter.