Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Once the query is applied, the Visit Date field in the Fields selection area does not show a Date icon.
When trying to write a measure using [Visit Date].[date], it does not recognize the field as a date and an error is received.
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!
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.
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.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
69 | |
68 | |
40 | |
29 | |
26 |
User | Count |
---|---|
89 | |
49 | |
44 | |
38 | |
37 |