Forum Discussion

mirzay's avatar
mirzay
Icon for Helper I rankHelper I
10 years ago

Automatic date column drill down not working as advertised

I followed the process in this tutorial here.  I have a simple revenue dashboard that I want to display revenue by year, quarter, month, day. I move the date column (type = date) in the X-Axis ...
Need Help
mirzay's avatar
mirzay
Icon for Helper I rankHelper I
10 years ago

I have a workaround if anyone else expereinces this. I duplicated the Date column as Date_1 in the model and ensured the type was also set to a type Date. If I use this new column, I get the hierarchy and it does what I want to do. 

 

I just marked the original Date column to do not show so there is no confusion when creating reports.

 

Seems like a Power BI bug to me.

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Are you using a dedicated date table or just a date type column in your regular data table?

  • mirzay's avatar
    mirzay
    Icon for Helper I rankHelper I
    10 years ago

    This is a date column in a fact table, not the Data table.