Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
umutkaya79
Helper I
Helper I

Slicer display 'The Last 2 days' as a default

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.)

 

umutkaya79_0-1688681431278.png

 

umutkaya79_1-1688681458479.png

 

umutkaya79_2-1688681479924.png

I am pretty sure it would be with a dax but couldn't figure. Thank you 

 

 

 

2 REPLIES 2
DemingPDCA
Helper II
Helper II

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. 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors