Forum Discussion
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...
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.
Hi,
Not sure, what is in your Date Dim,
But you could add the Month number column in your Date Dim as below :
-------
"Month",MONTH([Date]),
-------
and then use the particular column in your Sort process.
Not sure I it is working for you, but I usually use the number as a sort field for Date records