Show recent year in Matrix Visual

[Mohanad-Mustafa]

Hi Team,

I have a full calendar in my Power BI desktop dataset and I am trying to show the recent year like 2024 on the left side when I am creating a matrix visual, I always see the previous years first and then the current years, see screenshot below that shows my current issue:-

When I throw data in a regular table visual, the new year FY24/2024 shows up just fine and I am able to sort freely, my problem is when I have a matrix visual, it always shows the old years whether fiscal or calendar. 

Any help will be highly appreciated, thanks a lot 

[Mohanad-Mustafa · Accepted solution]

I found the solution on this post: https://community.fabric.microsoft.com/t5/Desktop/Need-help-How-to-get-Year-in-a-Matrix-Visual-colum...

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...