Year showing as serial numbers in my table vsisual

[Anonymous]

Hi,

I have a table visual which has the following column Year, Month, Total Orders and Prev Month Orders, the issue here is that Year is showing up as a serial number instead of 2021, 2020 etc.  My Year splicer on the page has 2021 selected.

In my Date table Year is set as a Whole number data type and Format is set as Whole number. I tried changed Data Type to Text and an error came up on my visual.

How do I get the Year in my table to show 2021 and not the numbers in my example below.

Year	Month	Total Orders	Prev Month Orders
62651	Jan	3388	3223
56588	Feb	3176	3388
62651	Mar	3552	3176
60630	Apr	3082	3552
62651	May	3227	3082
60630	Jun	3325	3227
62651	Jul	3503	3325

Any help on this is much appreciated!

[TheoC]

Hi @Anonymous 

How does you Year appear in your Date table?

I recommend creating a new Calculated Colum using the below to see if a new column results in the same outcome:

New Column = VALUE ( FORMAT ( [Date]; "YYYY" ) )

or 

New Column = YEAR ( Date[Date] )

This should return just the year as a value. 

Let me know what happens!

Theo 😃

[Greg_Deckler · Accepted solution]

@Anonymous I have a feeling that your year is set to numeric and you have an aggregation of SUM and that is the issue maybe? Try setting it to "Do not summarize".

[Anonymous]

Hi @Greg_Deckler ,

Thanks for this, my Year column is now showing 2021.