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.
Solved! Go to Solution.
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"
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.
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?
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:
Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.
Watch the playback of Session 26 with Ted Pattison!
Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.