Is it possible for a slicer to default to the current month?

Question

Need to have a dashboards modified to have all Time Slicers (month. pay period) automatically default to the latest month. This will eliminate the need to manually update and republish reports with data refreshes.

I tried but I couldn’t accomplish it

Ryan · Accepted Answer · 2025-01-15 01:03:06Z

1

maybe you can change the setting to relative date and set to this month

answered Jan 15 at 1:03

Ryan

2,6891 gold badge2 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sam Nseir · Accepted Answer · 2025-01-15 03:27:14Z

1

There isn't a native option for this in Power BI just yet. However, a common workaround, is to add an additional column to your Date table similar to:

YearMonth Cur = 
  IF(
    EOMONTH([Date], 0) = EOMONTH(TODAY(), 0),
    "Cur Month",
    [YourYearMonthColumn]
  )

Here is an example:

The idea is the default value remains the same, but gets calculated during dataset refresh. Remember to set "Sort on columns" for these new column(s).

answered Jan 15 at 3:27

Sam Nseir

13.1k2 gold badges5 silver badges21 bronze badges

Collectives™ on Stack Overflow

Is it possible for a slicer to default to the current month?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related