Forum Discussion

JustinDoh1's avatar
JustinDoh1
Icon for Post Prodigy rankPost Prodigy
5 years ago

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...
Need Help
HashamNiaz's avatar
HashamNiaz
Icon for Solution Sage rankSolution Sage
5 years ago

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 Date

 

Regards,

Hasham

JustinDoh1's avatar
JustinDoh1
Icon for Post Prodigy rankPost Prodigy
5 years ago

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"