Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have i date filter in my Power BI report (slicer type between). I need to configure it to default to show data for the last 8 months back from today's date.
I found an option to set up *Filter type: relative date, Show items: is in the last 8 months* , which works, but the problem is that I can't select in the from field an older date than the 8 months (I can only select from dates in the last 8 months, which is a bit strange behavior). How can I achieve the same result but with the option to choose any date (even older than 8 months etc).
Solved! Go to Solution.
Teach your users how to press the eraser button in your first image.
Your description is confusing to me. Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?
Hi,
1) I have a date filter (second picture in original post)
2) set this filter to relatative date (first picture in original post)
3) it shows data from last 8 months when i open report (8 months back from the current day)
4) in this setting I can't set a date older than the 8 months in the filter (which intuitively should be possible if I have them) - picture bellow
5) how do I get the filter settings to be the same and be able to select from all available dates (even those older than 8 months)
- date when i open the report is last 8 month from now... but cant select older records and cant solve this
Teach your users how to press the eraser button in your first image.
Thanks, that's probably the only right answer😁