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
    7 years ago

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

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

 

Sorry forgot to mention that I had checked this

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

Hi tiztrain

 

It seems you may try to add another table to set the order. Below is the article for your reference. If it is not your case, please share some data sample and expected output. You can upload it to OneDrive or Dropbox and post the link here.

 

http://www.excelnaccess.com/custom-sorting-in-power-bi/

 

Regards,

Cherie

  • PattemManohar's avatar
    PattemManohar
    Icon for Community Champion rankCommunity Champion
    7 years ago

    tiztrain Did you tried with this option on the chart.

     

    • tiztrain's avatar
      tiztrain
      Icon for Helper I rankHelper I
      7 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
        7 years ago

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