- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
Thanks in advance.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Exactly the same method worked for me too. Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Just adding that i've encountered exact same issue - i'm unable to change the duration or apply a relative date filter
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

The problem is that I cannot enter the period. I cannot enter anything in this field. It's like 'read-only'
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Tried it multiple times, no luck.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.
Join our Community Sticker Challenge 2025
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Subject | Author | Posted | |
---|---|---|---|
06-19-2019 10:02 AM | |||
04-04-2024 03:51 AM | |||
12-27-2023 01:25 AM | |||
12-04-2023 04:16 AM | |||
Anonymous
| 05-17-2021 07:52 AM |
User | Count |
---|---|
94 | |
67 | |
66 | |
44 | |
40 |