Forum Discussion
bo_afk
Post Patron
Post PatronIncorrect year in date hierarchy
Hi, I have a date column in my data with the following format dd/mm/yyyy. However, in my date hierarchy, which was automatically created in Power BI, the years it's returning is incorrect. It...
Hi vanessafvg , you're right. It looks like the date hierarchy is just adding in those extra years in the slicer even though the data doesn't actually exist.
When I filter for the incorrect years, it doesn't return any data.
bo_afkPost Patron
Post PatronHi vanessafvg , Anonymous. The data comes out of SQL server as date and appears as below in Power BI,
The hierarchy is created as this:
But when I filter for year, it shows the following:
vanessafvg
Community Champion
Community Championbo_afk any chance you can share your date table?