cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JustinDoh1
Helper V
Helper V

Slicer with date range (From date) not updated automatically

I  have my report scheduled to be refreshed everytday at Power Service (app.powerbi.com).

(BTW, I have posted this question previously, but I did not get the solution, so I am posting again)

 

But, I realized that From date at my Slicer that does not get updated automatically.

 

What is solution to have this From date range to be updated by itself?

To date gets updated because I slide all the way to the current date, but From date does not get updated.

Bottom are screenshots of my slicer:

JustinDoh1_0-1624926447778.png

 

JustinDoh1_1-1624923053703.png

 

 

Thanks.

 

 

 

4 REPLIES 4
HashamNiaz
Solution Sage
Solution Sage

Hi @JustinDoh1 !

 

Please try switching to Relative date slicer mode;

 

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range 

 

Seems you are looking for something like, Last 7 or 30 days to be your date range. You can use relative date slicer for that purpose.

 

Regards,

Hasham 

@HashamNiaz I just updated the image on my original post.

Actually, I am using Relative date, and it still doe not update correctly.

Hi @JustinDoh1 !

 

You can change the slicer layout between (List, Dropdown, Range, Relative), see the image below. Also you can then remove visual level filter on your slicer. You need to use Date element as Date rather than Date hierarchy for this option to be visible in Date slicer. Then from slicer hearder choose the dropdown icon & change it to relative date.

 

Relative DateRelative Date

 

Regards,

Hasham

@HashamNiaz Hi Hasham,

What I am trying to do is, I would like user to use a slicer that one can insert dates like how it shows as "between", but still having the default date ranges show up for last 14 days on a regular basis. Do I have to use other way to accomplish that (how user can insert two dates)?

 

I am not sure what you meant by "Also you can then remove visual level filter on your slicer"

 

 

 

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors