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'.