Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
nicocgn
New Member

Column Date not recognized in "Report View"

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 yousnip2.PNG

snip1.PNG

1 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

 

View solution in original post

4 REPLIES 4
nicocgn
New Member

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?

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.

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
Community Support
Community Support

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.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.