Forum Discussion

JimB-GA's avatar
JimB-GA
Icon for Helper III rankHelper 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
Icon for Super User rankSuper 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
Icon for Helper III rankHelper 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
    Icon for Resolver II rankResolver 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
      Icon for Helper III rankHelper III
      7 years ago

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

       

      Thanks!