Date slicer a week at a time?

[Kirt1965]

Hello all,

I am working with timecard data.  Every record has a week ending date on it.  We want to allow showing results based only on full week increments.  If I create a date slicer based off the week ending date, it still allows selecting any date that is not a week ending date.  In other words, it presents all dates in the range from earliest to latest.  What we want is to only allow choosing week ending dates.

How might we go about doing this?

TY in advance.

[Hazenm]

This is an old thread but in case anyone else is looking for an answer here, I came up with a quasi-solution. 

Create one column that is "Fiscal Year - Week" 

'Period Table'[Fiscal Year] & FORMAT('Period Table'[Week Number],"00")

Format this as a "Whole Number"  - this allows it to be a slider. This is funky because you have 53 - 99 that are empty, but it allows for the slider. 

And then create another column that is the exact same, but format this one as text. Use this text version on charts so that you don't show the empty 53 - 99 weeks on your charts when you are spanning across the years. 

Obviously, the original question was how to format as "Date Ending" - which you can only do categorically, and not continuous (which is the requirement for the slider). Don't have an answer there, unfortunately! But for me, this solves my main issue, which was: How do I allow users to easily select multiple fiscal week views that span across fiscal years, without having them to check a box for every single week. Definitely slightly funky with empty weeks on the slider, but users get over it quickly. 

[Kirt1965 · Accepted solution]

The solution is there's no solution.

[mussaenda]

Hi @Kirt1965,

I assume you are using date  range slider for your ending dates.

If you don't want the dropdown,

you can use week number instead of ending dates in slider?

Hope this helps.

[Anonymous]

HI @Kirt1965 

It is not possibel with the normal slicer. 

you need to get the below slicer and use the week date column.

[Anonymous]

Hi @Kirt1965 

As you already have week ending data.

Use the slicer to display a dropdown instead of slider on the week ending column.

[Kirt1965]

Thank you for the reply.  I should have been more clear.  I am aware I can display as a drop down.  I'm specifically asking how I could achieve the effect with the slider.  If it cannot be done with the standard slider, is there an alternative one available I could use?

[dkpmfa]

Have you tried adding a column to your timecard data?  You already have the last day of the week...add a column that calculates the week of the year WEEKNUM() (probably your fiscal year depending on how your company does it).  Then make the slider based on that.

You can use this to create your column:  

WeekNum = WEEKNUM(<your-date-field>)

I just gave this a try and it works fine.