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.

     

     

v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
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.

 

 

mkwiatkowski's avatar
mkwiatkowski
Frequent Visitor
6 years ago

Perfect! thank you, i've now got my chart showing dates chronologically.