Unable to drill down Calendar [Date] in charts

[Anonymous]

Hi,

I am trying to do a drill down in a Line and stacked column chart based on dates (comes from the Calendar table), but it's not letting me. When I put the date in the Shared axis, it doesn't give me the option to drill down to hierarchy or keep it like it is. Also, When I hover over my date field, I get this 'fieldListIdentity' tag on it. Has anyone else ran into this issue has found the solution? Thanks in advance! 

Line and stacked column chart: 


Visualization Panel:

Date field:

[Nolock]

Hi @Anonymous,

it looks like you don't have a date hierarchy. With a hierarchy it is generally possible to drill down.

[Anonymous]

That is what I am trying to get. The Date field isn't giving me this option like my other dates. 

[Nolock]

Please check if you can see this option when you click on your date column?

[Anonymous]

It does not give me that option.

 

[Anonymous]

Check that your Date field is classified as a Date Datatype. click on your modeling tab there should be a data type drop-down, make sure it says date. 

[Nolock]

Is it possible that this column has another data type than date?

Please, go to the ribbon Home and click on Edit Queries. Find your table in the list on the left hand site and check if the column is really a date column.

[Anonymous]

So this table is a Calendar table that pulls data from my schedule table. It's formatted as a date and it was working just a fine until I did the last two Power BI Desktop updates that adds a calendar icon next to all the date fields.  This particular field did not get that calendar icon and instead got some weird icon next to it ( see the last image from the original post above).

[tarunsingla · Accepted solution]

Did you mark your table as DateTable ? If so, you would need to define the date hierarchies yourself.

See this: https://docs.microsoft.com/en-us/power-bi/desktop-date-tables

"When you specify your own date table, you control the date hierarchies created in your model"

Alternatively, avoid mark your table as date table.

Regards,

Tarun
Did I answer your question? Mark my post as a solution!

[Anonymous]

@tarunsingla This worked! Thank you very much!