Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Automat year selection in slicer

Hi,

 

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

 

Need Help

5 Replies

  • Gengar's avatar
    Gengar
    Icon for Resolver I rankResolver I
    3 years ago

    Hi Anonymous ,

     

    You can use this! This is Relative Date slicer

     

    Gengar

     

  • Gengar's avatar
    Gengar
    Icon for Resolver I rankResolver I
    3 years ago

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

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

  • Gengar's avatar
    Gengar
    Icon for Resolver I rankResolver I
    3 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

      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.