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.

ngg4686's avatar
ngg4686
Frequent Visitor
10 years ago

You aren't the only one that this is happening to.  it seems like PowerBI isn't recgonizing the field as a date, so by adding a new column using the formula (my example anyway)

 

Act Ship Date = DATEVALUE('Source'[Ship Date]

 

If you do this, then the ship date behaves as expected.