Forum Discussion
Solved
Year Format
My year is coming out as a 6-digit number. I created a calendar with calendar auto and then added a year column with Year = Year('Date'[Date]). How can I make it a four digit year? It worked in a ...
Within your visual you probably have an implicit measure so it is probably summing up all your year values. In the visual click the drop down for the field and click dont summarise. Also select the field and under the modelling tab change the default summarisation to do not summarise.
Within your visual you probably have an implicit measure so it is probably summing up all your year values. In the visual click the drop down for the field and click dont summarise. Also select the field and under the modelling tab change the default summarisation to do not summarise.
Yep - it was summarizing! I had gone back and changed the column to format as "yyyy" and that worked but your solution is easier.