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
Doliveira
Frequent Visitor

Change the date format in x-axys label (Line Chart)

Hi,

 

After solve the problem reported at the post "Line Chart Label shows weekends entries" my chart are showing the dates as the following format:

 

1.jpg

(segunda-feira, 31 de Julho de 2017)

 

It's possible to change this format to 31/Jul (DD/MMM) ?

 

Tks

2 ACCEPTED SOLUTIONS
Anonymous
Not applicable

@Doliveira

 

Try with this:

 

= FORMAT(Table[Date];"DD-MMM")

 

Let me know how it goes.

View solution in original post

Hi @Doliveira,

 

If your chart not shows the summary data, you can try to modify the 'sort by column' property of this calculate column.

Sort by column in Power BI Desktop

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

@Doliveira

 

Try with this:

 

= FORMAT(Table[Date];"DD-MMM")

 

Let me know how it goes.

@Anonymous

 

No deal, follow the error:

 

2.jpg

Anonymous
Not applicable

@Doliveira

 

Try creating it as a coulmn. It should work.

Almost there @Anonymous! the label has changed, but the order of dates is incorrect:

 

3.jpg

Hi @Doliveira,

 

If your chart not shows the summary data, you can try to modify the 'sort by column' property of this calculate column.

Sort by column in Power BI Desktop

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

HI @v-shex-msft,

 

Thanks for this advice, that solve the label order !

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!