topic Re: Power BI report - default time range in Report Server

Power BI report - default time range

Tsko — Sat, 27 Apr 2024 18:44:11 GMT

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).

Re: Power BI report - default time range

lbendlin — Sat, 27 Apr 2024 22:13:53 GMT

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?

Re: Power BI report - default time range

Tsko — Sun, 28 Apr 2024 17:28:17 GMT

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

Re: Power BI report - default time range

lbendlin — Sun, 28 Apr 2024 20:26:43 GMT

Teach your users how to press the eraser button in your first image.

Re: Power BI report - default time range

Tsko — Mon, 29 Apr 2024 06:51:36 GMT

Thanks, that's probably the only right answer😁