Forum Discussion

mkwiatkowski's avatar
mkwiatkowski
Frequent Visitor
6 years ago
Solved

Line chart not showing dates chronologically

I Have a line chart that shows days and months, the issue i'm having is i want the chart to show the data chronologically by day/month, right now the chart seems to be ordering by day but rather doin...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    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.

     

     

DouweMeer's avatar
DouweMeer
Icon for Impactful Individual rankImpactful Individual
6 years ago

Either create a date hierarchy by click and drag the dates in a waterfall on top of each other, or use the 'Sort by column' in the modeling tab on top and use your date column for this purpose.