Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Default Behavior - Date Filter to Most Recent

I am currently using a fiscal calendar for my dashboard.  As pictured below, I have empowered the users to select Year and Week. The ideal scenario would allow me to default the slicers to current year and most recent week.

 

 

Is there any ability to do this?  

 

As an aside, the week number is formatted to text to ensure the chronological layout is correct.

 

Thanks for the help.

  • Anonymous,

     

    You may add an additional slicer by creating a calculated column. Also please vote this idea up.

    IsCurrentYear =
    IF ( Table1[Year] = YEAR ( TODAY () ), "Yes", "No" )
    

3 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support

    Anonymous,

     

    You may add an additional slicer by creating a calculated column. Also please vote this idea up.

    IsCurrentYear =
    IF ( Table1[Year] = YEAR ( TODAY () ), "Yes", "No" )
    
    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks v-chuncz-msft

       

      Can you help me understand the dax statement so I can learn how this solves the need?

      • v-chuncz-msft's avatar
        v-chuncz-msft
        Icon for Community Support rankCommunity Support

        Anonymous,

         

        Just select "Yes" as shown below.