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

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