Clustered Chart X-Axis months change around when slicer applied

[StuartPhillips]

I have a clustered chart showing previous and current quarterly data for the company as a whole, and a slicer which can be used to look at various areas of the company:

However, when I apply the slicer, for some areas of the company, the quarters stay in order, and for others, they switch around:

What is going wrong? I am thinking it is something simple that I have missed however.  How can i keep them in chronological quarter order?

Thanks in advance!

[Anonymous]

Hi, @StuartPhillips 

You can create a sort sequence and then try to fix the X-axis fields using the sort by column function.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum