Forum Discussion

CaseyM's avatar
CaseyM
Frequent Visitor
4 years ago
Solved

Matrix Table - Month Descending Order

Hello,   I am real familure with DAX and Power Query in Excel, but fairly new to Power BI.  I have searched the forums and found many issues on the topic, but I still cannot get it to work.     I...
Need Help
  • CaseyM's avatar
    CaseyM
    4 years ago

    Thank you both for responding.  I cleared all the confidential data and was going to add a sample pbix file, but then it worked!  I rebuilt the matrix visual without changing anything and it is working properly now.  Strange, but I am glad it is working now.

     

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi CaseyM ,

 

If you want to change the order of the month. You can use  sort by column function to sort your month as you want. Only import a table with unique month and an index column. Then create a relationship between these tables.

 

For example, you want let apr'22 as the 1st one and jan'22 as the 2nd... refer [index2], then sort [month] by index2.

 

Result:

 

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

 

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