Forum Discussion

tiztrain's avatar
tiztrain
Helper I
7 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:

v-cherch-msft's avatar
v-cherch-msft
Microsoft 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
Community Champion
7 years ago

tiztrain Did you tried with this option on the chart.

 

  • tiztrain's avatar
    tiztrain
    Helper 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
      Helper 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:

      • v-cherch-msft's avatar
        v-cherch-msft
        Microsoft Employee
        7 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