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.

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

Hi bo_afk ,

 

Is this problem sloved?
If not, please let me know.

 

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 , 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.