Date (period) slicer

[Anonymous]

Hi,

I am trying to default the start and end period on the slicer.

I have data that start from 201601 (January 2016) to 202312. so when I add a slicer it picks up that period range automatically , you have to type in the start and the end.

I am trying to default it to the current year like 201901 to 201912 by default.

Please help

[Anonymous]

the slicer I am trying to use

[v-xuding-msft]

Hi @Anonymous ,

Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution. More people will benefit from here. If you are still confused about it, please feel free to let me know. 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

You could try to use relative date filtering to implement it.

Reference:

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

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.