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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Radiolta
Regular Visitor

Dates formatted properly in Power Query Editor, but not in Report Fields

I am bringing in data from an Excel spreadsheet that includes dates.  The Power Query Editor recognizes the date column - Visit Date - as a date in applied steps. 

Radiolta_1-1629740872277.png

 

Once the query is applied, the Visit Date field in the Fields selection area does not show a Date icon.

 
 

Radiolta_4-1629742133536.png

 
 

When trying to write a measure using [Visit Date].[date], it does not recognize the field as a date and an error is received. 

Radiolta_6-1629741702218.png

 

Aside from making another custom column from the data, is there any way to make this field be recognized as a date in the Report area?   Thanks!

2 REPLIES 2
V-lianl-msft
Community Support
Community Support

This might be caused by the relationship.

When you have a date, Power BI automatically generate different views for different time hierarchies. But when you have a connection between tables (using date format) what happens is that the main date (table in which you have the one in one-to-many relationship) is the one that get the date hierarchy icon.

HotChilli
Super User
Super User

It will be a date.  Check the datatype of the column in powerbi front end.

Either you have switched off auto date/time settings OR there is a relationship with a date in a different table (and THAT date has the hierarchy).

All standard behaviour.

We always advise using a date dimension.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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