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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
Helper III
Helper III

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
Helper III
Helper III

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
Helper III
Helper III

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.