Forum Discussion

bo_afk's avatar
bo_afk
Post Patron
6 years ago
Solved

Sorting two date columns

In my data I have two date columns, one is RaisedOrder date and the other is DeliveryDate.   I've created a slicer (using the hierarchy slicer) for each of these columns by Year and Month name. Cur...
Need Help
  • bo_afk's avatar
    bo_afk
    6 years ago

    Hi V-lianl-msft , I solved it by bringing in the month number directly from the data source, along with the month name. I could then sort the month name by the month number and this looked to solve the issue.

     

    Initially I'd created a month number column within Power BI, based off of the date, and then sort the month name by this column but this didn't work.

bo_afk's avatar
bo_afk
Post Patron
6 years ago

Hi amitchandak , thanks for your suggestion. But when I try to do this, it gives me the error message "this column can't be sorted by a column that is already sorted, directly or indirectly, by column".

 

I don't remember sorting any other columns by this...but is it possible for me to double-check this?

 

 

amitchandak's avatar
amitchandak
Super User
6 years ago

Please make sure the sort column is not based on month-year column. Both of them can be based on the same base column-like Date.

 

  • bo_afk's avatar
    bo_afk
    Post Patron
    6 years ago

    Hi amitchandak , can you go through the steps again please? It doesn't seem to have worked for me.

     

    I have the following columns:

    RaisedDateRaisedYearRaisedMonthDeliveryDateDeliveryYearDeliveryMonthQuantity
    2020-01-032020January2020-03-142020March250
    2020-01-062020January2020-05-052020May100

     

    When I create a hierarchy slicer for DeliveryYear and Month, I get the following.

    • V-lianl-msft's avatar
      V-lianl-msft
      Community Support
      6 years ago

      Hi bo_afk ,

       

      There is a visual called "hierarchy slicer" in marketplace. Using this visual and applying the date hierarchy provided by powerbi can meet your needs.

       

      Best Regards,
      Liang
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • bo_afk's avatar
        bo_afk
        Post Patron
        6 years ago

        Hi V-lianl-msft , thanks for your feedback. Initially I used this slicer but it was adding in extra years and months that didn't exist in my data so I was unable to use it.