Forum Discussion
Helper IIDefault Date For Date Slicer
Hi tom-lenzmeier , Power BI doesn't natively allow slicers to always default to the current month. To mimic this, add a calculated column to your date table marking the current month (e.g., "Current" or offset = 0), use it in a slicer, and pre-select it before publishing; with custom visuals like "Button Slicer," selection can update automatically after refresh
Super UserHey tom-lenzmeier ,
I would suggest going with the text approach. At present, it is the cleanest approach to meet your requirement.
There is a sticky selection issue (or feature) in Power BI slicers. If you select something, it will retain that selection even if that selection is no longer available in table or the context (in simple terms, if you have two slicers one for Category and other for Subcategory, Cat A has SubCat A to SubCat D under it and Cat B has SubCat E to H, if you had selected the SubCategory slicer first and selected SubCat A and then gone to select Category B, the SubCategory slicer would still have SubCat A selected, even though it should not be under category B, and yes if you click on the slicer, you will see that selection SubCat A at the bottom and it will vanish if you remove the check mark). And the text approach "Current Month/Year" cleverly exploits this behavior.
Well while I can think of a way where you could set up a slicer that default selects the Sep 2025, but it would require setting up progressive disclosure with bookmarks and buttons, then converting the slicer to single-select with a force selection enabled along with desired sorting. Because I did something similar in the past and ended up hating bookmarks, I would not recommend this route.
Unless anyone here suggests a cleverer and clean approach, please save yourself the trouble and keep it simple with the text approach.
Hope it helps!