Forum Discussion

Zaky's avatar
Zaky
Helper IV
7 years ago
Solved

Sorting chart by Ascending

How can i sort bar chart by date ascending?

I have tried to play the more option at right corner of the visul, but it doesn't work.

 

3 Replies

  • Hi Zaky 

     

    The X-axis field looks suspiciously like a text field containing a formatted date which has been sorted lexicographically.

     

    Is the field on the X-axis of the column chart of type Date?

    If not, try putting "Ageing Date" itself on the axis, or set "Ageing Date" to be the Sort By column for the column used on the axis.

     

    Regards,

    Owen

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar

    Hi Zaky ,

     

    In addition, if your column in x axis is not the date type, you could try  sort by column feature in power bi.

     

    Please refer to this thread.

     

    Best  Regards,

    Cherry

    • Zaky's avatar
      Zaky
      Helper IV

      Many thanks! I managed to changed it accordingly.

       

       

      Regards,

      Zaky