Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
san17680
Helper II
Helper II

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

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

san17680_0-1689224960151.png

 

san17680_1-1689224960193.png

Please advise.

Thanks

 

 

1 ACCEPTED SOLUTION
Legend_11
Resolver I
Resolver I

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

View solution in original post

3 REPLIES 3
Legend_11
Resolver I
Resolver I

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

it works now Thanks a ton.

Legend_11
Resolver I
Resolver I

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/

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors