Forum Discussion
Solved
How to sort Legend months according to calendar sequence sorting? Starts from Jan and end Dec
Hi Community, In Clustered Column Chart, is there anyway to sort months according to calendar sequence? i.e. Starts from Jan and ends with December? Even when I sort according to Month, or accordin...
Hi joshtech
Based on your needs, I have created the following table.
You can use the following dax to merge two columns:
Column = [Year] &"-"&LEFT([Month],3)
Then change the format of the new column to "yyyy-mm".Then add a new column to the visual's X-axis to sort it:
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
