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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
NewPBIe
Helper II
Helper II

Column with Date Type is everywhere as "Date" marked but not in the Field Section and in the Visuals

Hello everybody

NewPBIe_0-1677660491674.png

 

As showed, Date Column is a Date but I cant's use it as a date in visuals. The source shows it correctly and In other PBI the field is also showed as a date. What is the problem?

 

Thank you

1 ACCEPTED SOLUTION

I followed both steps and it doesn't work. I just duplicated the column in power query and now it works with the new one

 

 

\(〇_o)/ 

 

Thank you @MAwwad

View solution in original post

3 REPLIES 3
MAwwad
Super User
Super User

It looks like the issue you're encountering is related to the data type of the column not being recognized as a date by Power BI.

To ensure that Power BI recognizes the column as a date, you can try the following steps:

  1. In the Power Query Editor, select the column that contains the dates.
  2. Click on the "Transform" tab, and then click on the "Data Type" dropdown list in the "Any Column" section.
  3. Select "Date/Time" from the dropdown list.
  4. Save and close the Power Query Editor.

Once you have completed these steps, the date column should be recognized as a date by Power BI and you should be able to use it as a date in visuals.

If the issue still persists, you can also try changing the data type of the column directly in the "Fields" section by right-clicking on the column and selecting "Data Type" > "Date/Time".

I followed both steps and it doesn't work. I just duplicated the column in power query and now it works with the new one

 

 

\(〇_o)/ 

 

Thank you @MAwwad

You are welcome, dont forget to accept it as a solution in order to help others as well

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors