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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
VinayakKarne
Frequent Visitor

Line chart x axis formatting for months

Hi Team, I am facing issue for ordering the months on x-axis of line chart. The month names are in Text data type. Below is the image of the data which i am getting result and the image in which format i needed.

 

Resulted dataResulted dataRequired Format DataRequired Format Data

1 ACCEPTED SOLUTION

OK,

Next step, order it by number of month, lets explain how:

 

In the query, I obtain the month number. Then, Ill go to modeling section, and select the field "Month", go to sort by column, and select the Month Number.

forum.JPG

tell me if works 🙂

View solution in original post

3 REPLIES 3
aoliver
Helper III
Helper III

try this:

In the top right corner, you should have a option for order, select month instead of sthe amount. 

Yes i tried it. Since the months are in text datatype. So it is arranging in asseniding or decending orger of alphabets of Months.image.png

OK,

Next step, order it by number of month, lets explain how:

 

In the query, I obtain the month number. Then, Ill go to modeling section, and select the field "Month", go to sort by column, and select the Month Number.

forum.JPG

tell me if works 🙂

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.