Forum Discussion
tom-lenzmeier
Helper II
Helper IIDefault Date For Date Slicer
Greetings! I'm wondering if there's been a solution for displaying the current month-year as the default date in a slicer. Many of the YouTube videos I've looked at all have something like "Curren...
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
Shahid12523
Community Champion
Community ChampionBest Option: Use a Relative Date Slicer → set to “In the last 1 calendar months.” Add a card with:
CurrentMonthYear = FORMAT(TODAY(), "MMM YYYY")
→ Shows “Sep 2025” dynamically.
Alternative: In your Date Table add:
IsCurrentMonth =
IF(YEAR('Date'[Date])=YEAR(TODAY()) &&
MONTH('Date'[Date])=MONTH(TODAY()), 1, 0)
Then use this in the slicer, preselect “1.”