Forum Discussion

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
5 years ago
Solved

Relative date slicer bug? - Last X Month ignoring first date

I wanted to verify that others are seeing the same behavior I am. When using a relative date filter and the Last X Months option, the first date in the range is being left out. I put together a s...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    Hi jdbuchanan71 ,

     

    Microsoft reply: bug filed internally, core issue identified.

     

     

    Best Regards,

    Icey

dedelman_clng's avatar
dedelman_clng
Icon for Community Champion rankCommunity Champion
5 years ago

There are some values where it works "properly", For Sept (30 day month), if you go back to July (3), May (5), March (7), December (10), or October (12) it works OK.

 

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
5 years ago

dedelman_clng 

I thought it might be that if the month you rolled back to had 30 days then the display would step back a day but then last 2 would not break because August has 31 days and it still rolls back to 7/31/2020.

It looks to be a descrepancy between the reported filter (the one on the bottom of the date slicer and in the filter tool tip on the cards) and the real filter (the one applied in the model).