Custom range date range slicer for start and end dates

[Meera556]

Hi,

I'm trying to create a slicer for the date column in my table

By default the report should be filtered to the last 30 days present in the date column and it should allow the user to select between the start and end dates

For example if an user opens the report today it should show as follows

start date - 1/06/2024

end date - 1/07/2024

Can anyone help me in creating this

Thanks for your help in advance

[Kishore_KVN]

Hello @Meera556 ,

In filters on this visual you can try this. Please look at the below screenshot

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

[Meera556]

Hi @Kishore_KVN ,

Thank you for your reply.

Its working fine with the range of 30 days but I need to select between the start dates and end dates

It is only allowing me to select between that 30 days time period, but I need to select from the start date available in the date column.

I have applied filter for 30 days then the 

start date is 1/06/2024 and end date is 1/07/2024 and when I'm trying to change the dates its only showing that 30 days date values only

My date column contains the values from jan 2024. I need to the slicer to show the values from jan 2024 and allow the user to select them.

Thanks for your help in advance.

[Anonymous]

@Kishore_KVN Thanks for your contribution on this thread.

Hi @Meera556 ,

Based on your description, it seems that you want the slicer to select the last 30 days by default. @Kishore_KVN has given you the way to do it by applying a relative date slicer. But at the same time you want the user to be able to select dates other than those 30 days as well. I'm afraid that's not going to happen, since the previous filter only selects dates that are 30 days old. You can submit a new idea. It is a place for customers provide feedback about Microsoft Office products . What's more, if feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Alternatively, to display only 30 days of dates, you could create a metric like this and apply a visual-level filter on the slicer just as below screenshot.

1. Create a measure as below

Flag =
VAR _today =
    TODAY ()
VAR _seldate =
    SELECTEDVALUE ( 'Date'[Date] )
RETURN
    IF ( _seldate >= _today - 30 && _seldate <= _today, 1, 0 )

2. Apply a visual-level filter on the slicer with the condition (Flag is 1)

Best Regards