Reply
zarmonas
Frequent Visitor
Partially syndicated - Outbound

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

Syndicated - Outbound

@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

Syndicated - Outbound

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

Syndicated - Outbound

@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

Syndicated - Outbound

Tried it multiple times, no luck.

Syndicated - Outbound

@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

Syndicated - Outbound

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

 

Syndicated - Outbound

okay





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

Proud to be a Super User!


LinkedIn


zarmonas
Frequent Visitor

Syndicated - Outbound

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

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)