Filter slicer and Bookmarks always on current Month

[neeleshbi]

Hello everyone!

I have built a new report with a monthly slicer/ filter.

Every user can select a specific month to get the values for our sales.

Is there any chance to have a dynamic filter, that is always filtered on the current month?

For now, I am using a bookmark that is updated monthly manually.

Ps. I asked the same question in a couple of other forums but received no proper reply.

[v-janeyg-msft · Accepted solution]

Hi, @neeleshbi 

According to your description, I think you can create a date table to display all the dates in the current month,new a relationship with main table date, then use it as a date slicer.

Table =
VAR a =
    YEAR ( TODAY () )
VAR b =
    MONTH ( TODAY () )
RETURN
    CALENDAR ( DATE ( a, b, 1 ), EOMONTH ( TODAY (), 0 ) )

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AllisonKennedy]

@neeleshbi  You can use the relative date slicer and set to in last 1 month, but this can only be done with a date slicer, not a month slicer. 

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range