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
zarmonas
Frequent Visitor

Unable to select duration in a relative date filter

Hello,

I'm having an issue with a relative date filter (same issues if I try to use a slicer).
I cannot edit relative date duration, it always shows "1-10000" and I can't press "apply filter" as well, it remains grey.

At first I thought, that the problem is in my date table - it was not "declared" as a date table, but when I did it, nothing has changed.
I tried to google this issue, but unfortunately could not find any information on what could cause it.

example.PNG
Thanks in advance.

1 ACCEPTED SOLUTION
DavidSercombe
Frequent Visitor

I've found a work around - this looks like it could be a bug, although co-workers are not experiencing it

 

First select 'is in this' [period]

The change it back to 'is in the last' [duration] [period]

 

Once I chaned the option back I could then amend the duration

 

View solution in original post

11 REPLIES 11
DavidSercombe
Frequent Visitor

I've found a work around - this looks like it could be a bug, although co-workers are not experiencing it

 

First select 'is in this' [period]

The change it back to 'is in the last' [duration] [period]

 

Once I chaned the option back I could then amend the duration

 

Exactly the same method worked for me too. Thank you!

DavidSercombe
Frequent Visitor

Just adding that i've encountered exact same issue - i'm unable to change the duration or apply a relative date filter

Arul
Super User
Super User

@zarmonas ,

You have enter the period eg:7 (refer the attached omage) first then you Apply filter option will be enabled.

Arul_0-1677489009678.png

Thanks,

Arul

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


zarmonas
Frequent Visitor

The problem is that I cannot enter the period. I cannot enter anything in this field. It's like 'read-only'

@zarmonas ,

Can you try to save, close and open the file and try again? Could be a technical glitch as well.

Thanks,

Arul





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


zarmonas
Frequent Visitor

Tried it multiple times, no luck.

@zarmonas ,

Not able to exactly replicate the issue in my end. Colud you send the sample file?

Thanks,

Arul





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


zarmonas
Frequent Visitor

Unfortunately, no, as it contains sensitive data.  I suspect that the problem lies in my date table, which has a massive code. 

I saved it in a txt file:

https://file.io/UFMb7xnUvbIU

 

okay





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


zarmonas
Frequent Visitor

Well, the problem is not in a Date table.
My collegue is using identical table, and he didn't encounter this issue.
Since I can't share  my file, the only option I have is waiting for someone who faced this issue as well.

Thanks for your help, Arul

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