Month name on x axis does not show totals correctly (Month number does)

[san17680]

hello,

I had posted this earlier, but the issue is still unresolved.

I am trying to get commulative ytd sales, it works fine when i drop month number on x axis, however it does not when i drop month name on x axis. I have attached images for reference. i have sorted the month number column in data table, however that did not help. Please advise.

Thank you

Please advise.

Thanks

[Legend_11 · Accepted solution]

Issue is because of not sorting the month name column, sort month name column based on Month Number, Hope this helps

[san17680]

it works now Thanks a ton.

[Legend_11]

As I see, the issue is because of sort order, the months are not in correct order however the values are showing correct,you can see dec as 7th month & june july moved to 8 & 9 .

please sort the month column ! hope this helps

https://databear.com/power-bi-tips-sort-by-month-name/