Forum Discussion

sailochanar's avatar
sailochanar
Icon for Helper II rankHelper II
3 years ago

Power BI

Hey Mates .... I have been trying to build a report where I'm stucked with a issue like month names are not in order ,even after sorting and tried many ways to sort ,by transforming data,adding new ...
Need Help
JorgePinho's avatar
JorgePinho
Icon for Solution Sage rankSolution Sage
3 years ago

Hello sailochanar! Do you have a calendar table? If so my suggestion would be to have a numeric column of month year where, for example, dec23 would be 1223 and june23 0623. Then you can order the original column based on the numeric one.

  • sailochanar's avatar
    sailochanar
    Icon for Helper II rankHelper II
    3 years ago

    Nope I just have month attribute ,Yeah I even created that as u said for Dec23-1223..But still the order is not sorted.(Splitting column ,conditions...) still not solved.

    • JorgePinho's avatar
      JorgePinho
      Icon for Solution Sage rankSolution Sage
      3 years ago

      Can you explain how you sorted using that column that I suggested? Or maybe share the report