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.
vanessafvg
Community Champion
Community Championbo_afk i would think the date hiearchy which i believe is actually a virtual table will probably pad the gaps between the dates, if you want more control over the date, create your own date table and your own hiearchy from the date table, i think that might give you more control
vanessafvg is correct BUT if you create a date table it MUST have continous dates.