racheldyer's avatar
racheldyer
Frequent Visitor
9 years ago
Status:
Accepted

Bug on drill

Hi,

I'm attaching a video of the problem: Drill works for some visuals and not others. 

 

Drill is on a date-based field (works fine on text), column chart. The date-based field is a calculated column we built to let Year-Month be a coninuous type. The DAX is this and it works fine

YrMoCharting = DATE(YEAR('QM_Import PatientAppointment'[FullDate]), Month('QM_Import PatientAppointment'[FullDate]),1) 

This shows up as 1/1/2016, 2/1/2016, 3/1/2016 etc. Please watch the video to see how it doesn't drill right

2 Comments

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee

    racheldyer

     

    I find that there is an existing issue already reported internally: CRI 29585614

    And the fix should be available by the end of February. Please check it in future release.

     

    Best Regards,

    Herbert