Forum Discussion
Relative Date Filter not working in filter pane
Hi,
I'm running across this problem with the relative date filter in Power BI desktop. It has a prepopulated number range and doesn't let me apply the filter even if I leave the number range as is. This date is coming from a date table in M code that I've used in the past. I verified that the date is formatted as a date field as well. I've never seen this happen before. It works in a slicer but the end user doesn't want a slicer on the canvas.
Thanks!
Hi Ashish - thanks for your reply.
It's the weirdest thing. I was preparing my response to you and went through every option under relative date to check and was able to apply the filter for Show items when the value 'is in this' day, and that worked. Now the other options are working. I don't know why that worked, but am just happy it did. I thought I was going crazy. 🙃
Best,
Jennifer
3 Replies
- Ashish_Mathur
Super User
Hi,
What happens when you type 1000 in the box in which you see the number range? Click on Apply filter.
Hi Ashish - thanks for your reply.
It's the weirdest thing. I was preparing my response to you and went through every option under relative date to check and was able to apply the filter for Show items when the value 'is in this' day, and that worked. Now the other options are working. I don't know why that worked, but am just happy it did. I thought I was going crazy. 🙃
Best,
Jennifer- Ashish_Mathur
You are welcome.
