Automatic date column drill down not working as advertised

[mirzay]

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 and hoping this will enable drill down. Value has the Revenue column. Tried with several bar charts and the table as in the tutorial. The Drill options do not appear in the chart and are greyed out in the menu as well.

Thoughts? Is there an overall config that may need to be enabled?

[v-haibl-msft]

@mirzay

Are you using the latest Version: 2.36.4434.381 64-bit (June 2016)? It is strange that it works with a duplicated date column.

It would be helpful if you can provide the .pbix file which can be used to repro it.

Best Regards,

Herbert

[mirzay]

Herbert Liu, Where should I upload the pbix? I will have to create a new source with just this issue as this is Financial data and cannot be openly shared/published.

[v-haibl-msft]

@mirzay

If possible, you can upload the pbix to OneDrive and share it.

Best Regards,

Herbert

[Habib]

Right Click on Date in X-Axis under settings and See if "Date" option is selcted or "Hierarchy". It should be hierarchy for drilldown feature.

[mirzay]

All I see is Remove Field and Show Options with no data.

[mirzay]

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]

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.

[KHorseman]

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

[mirzay]

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