Forum Discussion
Urgent Help: Set Date Slicer by Default to Current Week
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?
Super User
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 Series
ribisht17 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