Update Date Slicer Value To Show Current Month

[tecumseh]

Hi all,

Using PBID June, 2025.
I have a slicer connected to Date[Month Label]
I have another slicer connected to Date[Date]

Date[Date] shows 4/25/2025 which is the first date of data.
When I select "Current Month" from Date[Month Label] Matrices and Charts update correctly, but Date[Date] still shows 4/25/2025.
Is there anyway to get Date[Date] to show as 7/1/2025 as the start date for the current month?

Thanks,
w

[v-nmadadi-msft]

Hi @tecumseh 

As we haven’t heard back from you, we wanted to kindly follow up to check if the suggestions  provided by the community members for the issue worked. Please feel free to contact us if you have any further questions.

Thanks and regards

[v-nmadadi-msft]

Hi @tecumseh 

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you

[v-nmadadi-msft]

Hi @tecumseh 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[rohit1991 · Accepted solution]

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.