Forum Discussion
Urgent Help: Set Date Slicer by Default to Current Week
Most Valuable ProfessionalHi Brian415
This is a notoriously difficult requirement to deal with.
While it it possible to set a report to default to the range you are suggesting amd still allow some pre-defined flexibility (e.g. by using the method discussed here: Dynamic Date Range Slicer- Query M - Power Query / M Code Showcase - Enterprise DNA Forum), I have not found a good way to keep both Start and End og the period completely dynamic to the user.
My suggestion would be to use the above approach for your default page, and have a secondary page with a Between Slicer that they can adjust themselves (or perhaps a button to toggle between two bookmarks, instead of two pages).
_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data
Jonvoge Thanks for the quick response! Strange that a simple functionality like this is not possible. I am hoping someone maybe has a clue how you can achieve this easier. I almost refuse to believe there is no way to achieve this. Hopefully someone can help.
AmiraBedh amitchandak Any clue maybe?
- AmiraBedh
Super User
Sorry I saw your message late 🙂
- ribisht17
Please check https://community.fabric.microsoft.com/t5/Desktop/Date-slicer-default-to-the-current-week/td-p/1531599
This one with PBIX
Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Seriesribisht17 Thanks, but this doesnt work. Your first link for example; will limit the slicer behaviour to only the current week. I want that the date slicer is automatically set by DEFAULT current week. If the user wants to change it to another date, he should be able to trough adjustment. With this solution you are only able to see current week to my understanding.
Edit: Just realised that you were replying to someone else's comment not to mine, my bad there. Regadless i'll leave it in case it helps clarify my other suggestion.
Yes the default will be showing current week only, it worked in my case as i used the drop down selection of the week numers as a whole unit.
As below:
I couldn't find any other way to show by default a limited range unfortunately. It should definietly be a built in feature, would save a lot on unecessary hustle.
In your case, maybe you could make a sinlge tile slicer, where you'd put a calc column that lables the current weeks values as "click here to expand data" and blank for the other values.
So when the user clicks on it, it basically deselects the current week filtering and expands the data to the whole range
