Forum Discussion

tiztrain's avatar
tiztrain
Icon for Helper I rankHelper I
8 years ago
Solved

Sort by another column issue

So currently I am trying to display the date and month in order but get the following:      I have setup my calendar table as:   PROD Calendar = VAR Days = CALENDAR(MIN('LCP_Contacts'[Vis...
Need Help
  • tiztrain's avatar
    tiztrain
    8 years ago

    I just found a work around by adding the "Date Month Number" field to the Tooltips and then I can sort:

PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
8 years ago

tiztrain Did you tried with this option on the chart.

 

tiztrain's avatar
tiztrain
Icon for Helper I rankHelper I
8 years ago


The chart displays in Date Month Text but I want to sort by the Date Month Number.

 

How can I add this as an option to sort by?

  • tiztrain's avatar
    tiztrain
    Icon for Helper I rankHelper I
    8 years ago

    I just found a work around by adding the "Date Month Number" field to the Tooltips and then I can sort:

    • v-cherch-msft's avatar
      v-cherch-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi tiztrain

       

      Glad to hear you've solved it, please accept the helpful answer or your solution as solution, that way, other community members will easily find the solution when they get same issue.

       

      Regards,

      Cherie

      • tiztrain's avatar
        tiztrain
        Icon for Helper I rankHelper I
        8 years ago
        I was still wondering if there is a better way to do it?