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
    Impactful Individual
    6 years ago

    That method is not an effective trick for this situation. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      DouweMeer :

      If the date column is sourcing Dim/Calendar table from database. Date must be is Unique/PK, then

      1. In Power Query Editor', Sort Date column

      2. Add Index column

      3. Close & Apply

      4. From Data view create new column as you wanted.

              DaynumerWithMonthName = FORMAT(Hours[Date],"dd,mmm")

      5. Now  in the 'modeling' tab, select the new column and select 'Sort by Column' and choose Index column.

       

      Note: If the Date column is not unique from the Source, then select Date column and create new table y selecting 'Add as new Query, then 'Remove Duplictates', THEN convert 'To table'.