Show dates as a hierarchy

[Anonymous]

There is an update in Analytics section in Power BI Desktop Update - March 2019  'Show dates as a hierarchy now generally available', my understanding is the date column in my existing PBI report would show as hierarchy (Year/Quarter/Month) after the  upgrade, but after I upgraded the software, I found there is no '+' sign ahead of the date column in fields to show dates as a hierarchy, do I need do something else to make it work?

[Nolock]

Hi @Anonymous,

unfortunately I don't see your data model, but there can be 2 things you should try.

1.  The data type of your date column must be date or date/time - see a screenshot below.
2.  Visualize the column as date hierarchy instead of the column value itself - see the second screenshot below.

Ad 1.

Ad 2.

[Anonymous]

Hi @Nolock , thanks for the reply, the table/column in my PBI report are not created using Power BI, it's created in Azure server initially, then deployed to Power BI through Visual Studio tool, the column type showed in Visual Studio is 'Date':

But in Power BI fields, when I right click the column name 'EOM', the 'Date Hirarchy' selection you showed in 'Ad2' is not visible.

[Nolock]

Hi @Anonymous,

have you checked that the column OEM has the data type date in Power BI? It's the step 1 in my previous post.