Line chart visual | Convert dates into months

[jhtate]

I am having an issue getting my line chart to display months instead of exact dates.

I have a line chart which counts the number of entrys per month however it displays the entry on each date instead.

Is there a way to sort the dates to have them displayed as months in the line chart?

[Anonymous · Accepted solution]

Hi @jhtate ,

The data type of the field should be text instead of date.

Please check select that field then Modeling->Formatting if it is a date field.

and you could also use Sort by column in Power BI Desktop.

You may also check if these thread helps:

How to sort months chronologically in Power BI (sqlshack.com)

Solved: Date Sorting in Line Chart - Microsoft Power BI Community

Best regards.
Community Support Team_ Caitlyn