Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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.