Forum Discussion
Line chart visual | Convert dates into months
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?
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
1 Reply
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