Drill down on Matrix no longer an option after marking date dim table as date table
I have a matrix that I created that used a date dim table date field as one of the values. I wanted to add some previous months calculations to the matrix. In order for my dax to work properly, I marked the date dim table as a date table. Now however, The date field from the date dim table no longer shows a time hierarchy (year-> quarter -> month). it only has stagnant dates (1/1/2023). If you use the date field from the date dim table in a visual, does marking the date dim table as a date table prohibit the drill down feature? After marking the date dim table as a date, I now have this icon next to the field. Has anyone found a way to mark the date dim table as a date table, but still be able to use it in visuals that will allow the drill down feature?
