Forum Discussion
Line chart not showing dates chronologically
Hi mkwiatkowski ,
We can use the tooltips field to sort the chart if the x-axis field is based on the column you want to sort, or you have a hierarchy field used as x-axis, just put the date field into the tooltips then set sort as this field
BTW, pbix as attached.Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi mkwiatkowski ,
We can use the tooltips field to sort the chart if the x-axis field is based on the column you want to sort, or you have a hierarchy field used as x-axis, just put the date field into the tooltips then set sort as this field
BTW, pbix as attached.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Perfect! thank you, i've now got my chart showing dates chronologically.
Why are you guys making your lifes more complicated than necessary? And most important, why are you teaching others to work as complicated as well. The problem lies in the fact that the field is considered text. Thus it sorts alphabetical. You have to let Power BI know it is dealing with a date related value.
ComparisonDate column by formatDate by default hierarchyDate by custom date hierarchy
