Unable to select duration in a relative date filter

[zarmonas]

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.

[DavidSercombe · Accepted solution]

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

[zarmonas]

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

[DavidSercombe]

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

[Arul]

@zarmonas ,

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

Thanks,

Arul

[zarmonas]

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

[Arul]

@zarmonas ,

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

Thanks,

Arul

[zarmonas]

Tried it multiple times, no luck.

[Arul]

@zarmonas ,

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

Thanks,

Arul

[zarmonas]

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

 

[Arul]

okay

[zarmonas]

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