Year 2020 displaying as "202"

[StuartSmith]

I'm sure I have asked this before, but unable to find the question in my previous questions or by searching, so hopefully someone can help.

I am importing an excel file into Power Bi and there are multiple columns with the format Calendar week.Year "01.2020", but for some reason all columns for 2020 are displaying as "Calendarweek.202" and not "Calendarweek.2020".

Any ideas why its cutting off the "0" at the end.

Thanks,

[Anonymous]

@StuartSmith  Please check if the DataType of the "CalendarWeek.Year" column is changed in Power Query editor.

It would be really helpful to point to exact issue if we have a sample of data.

[amitchandak]

@StuartSmith , difficult to say without looking at data.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[StuartSmith · Accepted solution]

@amitchandak I just remembered how I fixed it last time.  I switched off "Type Detection" and now the year "2020" is displaying correctly.

Thanks