visual |decomposition tree - date display issue

[Anonymous]

hi,

ref screenshot of the decomposition tree below -

the year in the tree header of this decomposition tree visual is not right. in other visuals, the year is shown correctly. kindly advise what to rectify it.

tks & krgds, -nik

[lbendlin]

Where does that year come from, an auto date/time hierarchy?  Try using a dedicated calendar table.

[Anonymous]

hi @lbendlin,
it's created using a dedicated calendar table.

krgds, -nik

[lbendlin · Accepted solution]

Looks like you formatted a date as Year. You need an actual separate year column, as a number or text, not as a date.

[Anonymous]

tks again @lbendlin.

as suggested, i solved it by creating a new text-formatted year column by means of adding following line in in the calendar table:
 

"Year ", FORMAT ( [Date], "yyyy")

krgds, -nik