Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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
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
You are welcome.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |