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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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