Matrix column in Reverse order

[Prakash1050]

Hi All, 

I have one matrix visual. That matrix column have Month_Year_Format column from calender table in below snip.

But, here that column is showing descending order. I need to change in ascending order.

It is possible? 

Please help me.

Thanks in Advance.

[Ritaf1983 · Accepted solution]

Hi @Prakash1050 
You need to sort the column of month year by its numeric value from the data view:

The logic of the year_month_code is year&month (just concatenate it and make it whole number data type)

P.S
If the sorting is currently in reverse order, it's highly likely that it’s being sorted based on a similar logic, but multiplied by negative one, which causes the order to go from largest to smallest. So, the column for sorting might already exist.

My pbix is attached

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

[rajasaadk_98 · Accepted solution]

To resolve the issue of the Month_Year_Format not showing in the correct order in your Power BI Matrix visual, follow these steps:1. Ensure Proper Sorting of Month_Year_Format Column:

The Month_Year_Format column might be sorting alphabetically (e.g., April before January) instead of by chronological order.

Steps to Fix:

Option 1: Sort by a Supporting Column

1. Add a Month Index: In your calendar table, ensure you have a column that represents the month in numerical format or the year-month index. For example:

   • Month_Number (1 for January, 2 for February, etc.)
   • Or YearMonthIndex (e.g., 202301 for January 2023, 202302 for February 2023, etc.)

2. Sort Month_Year_Format by this new column:

   • Go to the Data view in Power BI Desktop.
   • Select your Month_Year_Format column.
   • On the On the ribbon, click "Sort by Column" and choose your Month_Number or YearMonthIndex column.

[Ritaf1983 · Accepted solution]

Hi @Prakash1050 
You need to sort the column of month year by its numeric value from the data view:

The logic of the year_month_code is year&month (just concatenate it and make it whole number data type)

P.S
If the sorting is currently in reverse order, it's highly likely that it’s being sorted based on a similar logic, but multiplied by negative one, which causes the order to go from largest to smallest. So, the column for sorting might already exist.

My pbix is attached

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