Forum Discussion
Advocate IIIShow recent year in Matrix Visual
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
2 Replies
- lbendlin
Super User
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-Forum/ba-p/963216
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/1447523 
Mohanad-MustafaI found the solution on this post: https://community.fabric.microsoft.com/t5/Desktop/Need-help-How-to-get-Year-in-a-Matrix-Visual-colum-to-display/m-p/3642295#M1192359
