X-axis using field parameter

Thanks for the reply from shafiz_p , please allow me to provide another insight:

Hi, Syndicate_Admin 
Thanks for reaching out to the Microsoft fabric community forum.

Has shafiz_p's response resolved your issue? If it has, please accept it as the solution. This will help other users with similar problems find solutions more quickly.

In my tests, it was effective. Below is an image of my results:

To generate a month number column, you can use the MONTH() function to create a calculated column. In my tests, this did not result in any circular dependency issues.

MONTH function (DAX) - DAX | Microsoft Learn

For more details on shafiz_p's solution, you can refer to the following documentation:

Sort one column by another column in Power BI - Power BI | Microsoft Learn

Please find the attached pbix relevant to the case.

 
Of course, if you have any new discoveries or questions, please feel free to get in touch with us.
 

Best Regards,

Leroy Lu