Forum Discussion

Pbiuserr's avatar
Pbiuserr
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

Current month filter visual bug

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('C...
Need Help
  • Pbiuserr's avatar
    Pbiuserr
    4 years ago

    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's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

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's avatar
Pbiuserr
Icon for Post Prodigy rankPost Prodigy
4 years ago

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's avatar
    v-yanjiang-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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