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 UserI prefer using the filter pane for a several reasons filters - one of them is this... If you have a date field in your filter pane, you can have it set to 'Is in this month' or whatever you need and then if your users need something different, they simply change it - and not just change how many months, they can change it from relative to advanced to basic filter so they get full range of motion 🙂