Forum Discussion
visual |decomposition tree - date display issue
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 a...
Looks like you formatted a date as Year. You need an actual separate year column, as a number or text, not as a date.
Where does that year come from, an auto date/time hierarchy? Try using a dedicated calendar table.
hi lbendlin,
it's created using a dedicated calendar table.
krgds, -nik
Looks like you formatted a date as Year. You need an actual separate year column, as a number or text, not as a date.
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