Power BI

[sailochanar]

Hey Mates ....

I have been trying to build a report where I'm stucked with a issue like month names are not in order ,even after sorting and tried many ways to sort ,by transforming data,adding new col,slicing blah blah ...still didnt yet solved.

Kindly suggest the solution.

 Observe tht image where in X-axis month names are not in order .Thats the Issue ,I'm facing.

Thanks ..!

[sailochanar]

I splitted the month column which is filled with Jan'23,Feb'23....so on ,and added another column with Month_number and merged all three. still even after sorting with mnth number also it is not getting sorted . Please suggest a simple way if possible.

[JorgePinho]

Hello @sailochanar! Do you have a calendar table? If so my suggestion would be to have a numeric column of month year where, for example, dec23 would be 1223 and june23 0623. Then you can order the original column based on the numeric one.

[sailochanar]

Nope I just have month attribute ,Yeah I even created that as u said for Dec23-1223..But still the order is not sorted.(Splitting column ,conditions...) still not solved.

[JorgePinho]

Can you explain how you sorted using that column that I suggested? Or maybe share the report