Automat year selection in slicer

[Anonymous]

Hi,

how can i selecet latest 3 years / Months / Date automatically in the slicer?

[Gengar]

Hi @Anonymous ，

Maybe you can create a flag measure to help

filter your data.

For example: create a meaure to calculate the date,if it is in the range, then return 1.

After you create the measure then apply

it to the visual level filter.

Hope this could help you!

Ganger

[Anonymous]

Hi,

Thanks for the response, However, sadly it does not make solution to my problem.
I want to select 3 latest financial year automatically.


Please check the below snip and suggest something.

[Gengar]

You can click here to change the type of your slicer:

[Anonymous]

I am just getting Dropworn and list option only, now what a suppose to do?

[Gengar]

Hi @Anonymous ,

You can use this! This is Relative Date slicer

Gengar