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

[Doliveira]

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:

(segunda-feira, 31 de Julho de 2017)

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

Tks

[Anonymous · Accepted solution]

@Doliveira

Try with this:

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

Let me know how it goes.

[Anonymous · Accepted solution]

@Doliveira

Try with this:

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

Let me know how it goes.

[Doliveira]

@Anonymous

No deal, follow the error:

[Anonymous]

@Doliveira

Try creating it as a coulmn. It should work.

[Doliveira]

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

[v-shex-msft · Accepted solution]

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

[Doliveira]

HI @v-shex-msft,

Thanks for this advice, that solve the label order !