cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Prodigy
Post Prodigy

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.

 

Capture.PNG

 

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.

2 ACCEPTED SOLUTIONS
Community Support
Community Support

@irnm8dn,

 

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" )
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

@irnm8dn,

 

Just select "Yes" as shown below.

Capture.PNG

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Community Support
Community Support

@irnm8dn,

 

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" )
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Thanks @v-chuncz-msft

 

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

@irnm8dn,

 

Just select "Yes" as shown below.

Capture.PNG

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors