Update Date Slicer Value To Show Current Month

Hi tecumseh ,

 

This is a common ask, and unfortunately there’s no direct way in Power BI to automatically sync one slicer’s selection (like [Month Label]) to another slicer (like [Date]) so that [Date] always jumps to the start of the current month when “Current Month” is selected. Slicers work independently, and changing one won’t update the selection in another.

 

Here are the practical workarounds:

 

1. Use a Relative Date Slicer: If your goal is to always see the current month, set your [Date] slicer to "Relative" and choose "is in this month." This way, it always shows the current month, and moves forward automatically each month.

 

2. Add a Helper Column: Add a calculated column to your date table, such as: IsCurrentMonth = YEAR([Date]) = YEAR(TODAY()) && MONTH([Date]) = MONTH(TODAY())

 

3. Use Bookmarks as a Shortcut: You can pre-select the slicer for the current month and save it as a bookmark. Add a button to your report so users can click and jump to the current month’s data.

 

4. Sync Slicers (if possible): If both slicers are using the exact same field from your date table, you can sync them in the View tab (View > Sync Slicers). But this only works if they’re based on the same column, so it may not fit your case if you want one by label and one by date.

 

There’s no out-of-the-box way to have the [Date] slicer change its value automatically based on a [Month Label] selection unless you get into custom visuals or advanced embedding with the Power BI API, which is usually overkill.