Column Date not recognized in "Report View"

[nicocgn]

Hello,

I have a PBI where I import a Database with a column with a Date which is recognized as type "Date" both in Power Query and in "Data View". However, it is not recognized as Date in "Report View" (there is not the icon calendar).

In other Forum I see that I can "replicate" a data hierarchy by my-self, but still there are some functionalities that does not work if I do not have the date set as "Date" in Report View (for example I cannot create a quick measure YoY Change%).

I have tried the following:

- upload the file both as Table and as Range

- check the option "Time Intelligence" in Data Load.

Any other Idea?

Thank you

[nicocgn]

Hi, thank you for your answer. I have tried with the documentation but still I cannot see the date as Date Hierarchy.

I have tried to upload a new table with just a column with the date, and I tried to convert the excel documento to text/csv but still not working. Any other idea?

[v-jianboli-msft]

Hi @nicocgn ,

Sorry, I can't reproduce your issue on my side.

Please provide me with more details about your table and your data model or share me with your pbix file after removing sensitive data.

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nicocgn · Accepted solution]

Hi, it seems I solved the problem by updating the PBI version and by replicating the work on a new PBI workbook. Seems the other one was somehow compromised.

Thank you anyway

[v-jianboli-msft]

Hi @nicocgn ,

It seems that your date field does not display date hierarchy.

Here is a document about this:

Why there is no date hierarchy - Microsoft Fabric Community

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.