Date Hierarquy not working for year aggregation

[vgarciasouza]

Hello,

I have a matrix with the dates on the column.  When I use the date hierarquy it aggregates correctly the dayli and monthly values, but it doesn't recocnize the year. Have anyone faced similar issue?

[Anonymous · Accepted solution]

Hi @vgarciasouza ,

It seems like you are facing an issue with the year aggregation in Power BI.

Please check the following:

• Ensure that the date column is formatted as a date type.
• Mark the table as a date table.
• Create an error-free relationship between the tables.
• Use a custom date hierarchy.
• Enable the Auto date/time option from the Power BI Options.

Fix Power BI Date Hierarchy Not Showing [5 Easy Ways] (10pcg.com)

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.