Forum Discussion

JimB-GA's avatar
JimB-GA
Helper III
7 years ago
Solved

Unable to sort by date rather than value

The community is a life saver to me as I teach myself Power BI.  Thanks for all the support.   I have created a date table that includes date, date as integer, and YearMonthName.  I have a clustere...
Need Help
Tutorial Requests
  • adambhappy's avatar
    adambhappy
    7 years ago

    Can't you just switch the Sort by column for YearMonthShort to the YearMonthNumber column?

parry2k's avatar
parry2k
Super User
7 years ago

JimB-GA yo also need to change the sort order, you just selected which field to use for sorting

 

  • JimB-GA's avatar
    JimB-GA
    Helper III
    7 years ago

    I changed sort order.  The previous graph illustrates setting for ascending order.  Here is what descending order looks like:

     

     

     

    • adambhappy's avatar
      adambhappy
      Resolver II
      7 years ago

      Can't you just switch the Sort by column for YearMonthShort to the YearMonthNumber column?

      • JimB-GA's avatar
        JimB-GA
        Helper III
        7 years ago

        That worked.  Would like to use other date option but this works.

         

        Thanks!