Current month filter visual bug

[Pbiuserr]

Hello

Ive created current month filter

Current period = Switch( True(),
eomonth('Calendar'[Date],0)= eomonth(Today(),0),"Current Month:" &" "& Format('Calendar'[Date],"MMM YYYY") ,
Format('Calendar'[Date],"MMM YYYY")
)

It looks good, the date has changed to april with the current month in "Data tab" however, on slicer I can still see: Current Month: Mar 2022. 

Is there a way to automatically change to Apr 2022 without doing it manually? also - is under the hood still March data, if March appeared as Mar 2022 and first entry is Apr 2022?

[v-yanjiang-msft]

Hi @Pbiuserr ,

Unfortunately I cann't reproduce your problem. Is your formula a calculated column, then put it in a slicer?

I attach my sample below, could you please point out how your sample is different from mine?

Best Regards,
Community Support Team _ kalyj

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

[Pbiuserr · Accepted solution]

Hi,
Thanks for your input. My problem has been solved - there cannot be &FORMAT(Calendar[YEAR-MONTH] because it doesnt work in UI. Just set it to current month and made a additional layer with shape which has measure of SELECTEDVALUES(Calendar[YEAR-MONTH) and put it on silcer display so the selection remains Current Month but it shows Apr 2022 as for now, in May it will change

[v-yanjiang-msft]

Hi @Pbiuserr ,

Glad your problem is solved, you can mark your answer as the solution to help the other members who have same problems find it more quickly.

Best Regards,
Community Support Team _ kalyj