Matrix Column Head Order

[srisiva55]

Hi have Data of Year field in below format 

Year

2019-20

2020-21

2021-22

2022-23

But when I used this field in Matrix column giving as   But business expecting 2021-22 first then 2020-21 also the values based on Year column. I tried various option but since this data with 2020-21 as not number I unable to do that. Please help on this.

[srisiva55]

Hi 

Since you asked sample data , I provided in below also attached Screenshot to better understand the requirement that column order should be in below for matrix in power bi.

For ex: if user selectes 2021-22 then order of matrix column should be 2021-22  then 2020-21 .. Currently it's showing 2020-21 then 2021-22 ..

Also below fiscal year is dynamic , Should not be any static / constant values ..can expect new fiscal year 2023-24 .. In this case should display 2023-24 first then 2022-23 .  Any solution will be much appreciated .. 

Asset Type	Metric Name	Fiscal Year	Amount
Internal	Property	2020-21	4500
Internal	Property	2021-22	3400
Internal	Property	2022-23	2600
Internal	Equipment	2020-21	5366
Internal	Equipment	2021-22	7400
Internal	Equipment	2022-23	4300
External	Property	2020-21	3233
External	Property	2021-22	3400
External	Property	2022-23	3244
External	Equipment	2020-21	5366
External	Equipment	2021-22	300
External	Equipment	2022-23	3244
Cash Equivalants	Property	2020-21	3233
Cash Equivalants	Property	2021-22	3244
Cash Equivalants	Property	2022-23	3243
Cash Equivalants	Equipment	2020-21	7465
Cash Equivalants	Equipment	2021-22	8366
Cash Equivalants	Equipment	2022-23	8466

[Anonymous]

Hi @srisiva55 ,

You can create a dimension table with the proper orders as below:

Then sort the column [Year] by [Order], create a visual as below screenshot. Please find the details in the attachment.

In addition, you can refer the following link to get it:

Sort a Column with a Custom Order in Power BI - RADACAD

If the above one can't help you, could you please provide some raw data in your table (exclude sensitive data) with Text format and your expected result with backend logic and special examples? It would be helpful to find out the solution. You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards