Date column wont create summary by year

[Justas4478]

Hi, I am trying to make my matrix table to look like the one in the exel on the right side.
But when I put date column it only shows me dates and even after changing format it displays years but for each row and not in a collapsable hierarchy format.
Anyone know what is the problem?

[Anonymous]

Hi @Justas4478 

Your problem is that since the date format of your ETA column is "dd-mm-yy" and the date format in Power BI is "mm-dd-yy", you just need to swap your date position with the month position

^{Best Regards,}

^Jayleny

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

[Justas4478]

@Anonymous I tried to do what you suggested, but the only options I get are these in the format list.
I tried choosing mmmm yyyy, but that did not solve it.

[Anonymous]

Hi @Justas4478 

Here's a sample image from where you started

The date format of this column of yours is wrong, make sure the date format of this column of the data you import is in mm-dd-yy format, similar to "1/25/2024" instead of "25/1/2024"

The image you replied to only has the month and year in the columns, not the date, so there is no mm-dd-yy option

If this reply doesn't help you solve the problem, please provide your PBIX file.

Best Regards,

Jayleny

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

[Justas4478]

@Anonymous I changed formating back to the default formating.
I am still not getting now choices on the formating list.

The only way how I see that I can change to different date format would be eather to change in the excel file that I import or to use power query in transform window.

[Justas4478]

I manage to solve the problem by creating Calendar table and linking it to data table.

If anyone know solution that works without need to create calendar table please let me know.