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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Karola
Advocate I
Advocate I

default date selection but with possibility to change dates

Hello, 

 

I have the following graph (as example) and the date selection now has all the dates known. 

Image 2.png

I have the following wish from a customer and that is to have a default date set on 30 days.

Now i can do that with a filter on the page like below...

Image 5.png

BUT.. now comes the questionable part... He also wants to be able to change the date selection and see further back. 

but if you change the date from 12-4 to 1-4 for instance, nothing happens because there is a filter on the date. 

 

Does anybody have a brilliant solution without changing the datepicker itself. 

3 REPLIES 3
v-yingjl
Community Support
Community Support

Hi @Karola ,

Since you set the relative date filter on this report page, all the visuals on this page would be affected by this page filter instead of the visual filter.

 

In addition, relative date and normal date filter could not be used at the same time in the visual. If wants to filter visual by slicer in 30 days, you can create a measure like this, put it in the visual filter and set its value as 1:

visual control = 
VAR _maxdate =
    CALCULATE ( MAX ( 'Table'[Date] ), ALLSELECTED ( 'Table' ) )
RETURN
    IF (
        SELECTEDVALUE ( 'Table'[Date] ) >= _maxdate - 30
            && SELECTEDVALUE ( 'Table'[Date] ) <= _maxdate,
        1,
        0
    )

visual filter.png

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

this will not really fix my problem. because it only works when using the date with a before and it only shows the 30 days before that date.. i just want to use the between date and have a default 30 days when i open.. but then be able to change the date selection. so i want to see from 1-1 till 15-5 that should be possible, but everytime i open the report it shows the last 30 days. 

amitchandak
Super User
Super User

@Karola , Independent date table can help (Select a range/date and show more or less dates on axis) , refer to my video if that can help you

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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