Forum Discussion

GemcoDesigns's avatar
GemcoDesigns
New Member
6 years ago

Month Sorting

I have create one report( Purchase Monthwise..

 

But the months are not sorting...

 

and it lokks like as per the image.

 
 

 

 

 

Can any one help me to overcome this:)..

Need Help

4 Replies

  • FrankAT's avatar
    FrankAT
    Community Champion
    6 years ago

    Hi,
    select the visualization and click the three points in the upper right corner. Choose how to sort.

     

    Regards Frank AT

  • MartynRamsden's avatar
    MartynRamsden
    Solution Sage
    6 years ago

    Hi GemcoDesigns 

     

    Your visualisation looks like it's sorted by Purchase Amount descending.

    Click the ellipsis (...) in the top right hand corner of the chart and select Sort by>>Month.

     

    When you do this, you may find that your months are sorted alphabetically rather than chronologically.
    If so, you need to add a 'Month Sort' column to your model as detailed here: docs.microsoft.com/en-gb/archive/blogs/samlester/sorting-by-month-names-in-power-bi 

     

    Best regards,
    Martyn


    If I answered your question, please help others by accepting it as a solution.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    This is how I had to fix my visual with a similar issue. It wouldn't let me sort using my Date values for whatever reason so I wrote this and sorted that by my Date columns

     

    Month Order =
    var num = MONTH('TableName'[DateColumn])
    return
    IF(num = 1, "January",
    IF(num = 2, "February",
    IF(num = 3, "March",
    IF(num = 4, "April",
    IF(num = 5, "May",
    IF(num = 6, "June",
    IF(num = 7, "July",
    IF(num = 8, "August",
    IF(num = 9, "September",
    IF(num = 10, "October",
    IF(num = 11, "November",
    IF(num = 12, "December"
    ))))))))))))
  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    For the month and month year sorting; create sort column and mark them sort column

     

    month year = format(date[date],"MMM-YYYY")

    month year sort = format(date[date],"YYYYMM")

     

    month= format(date[date],"MMMM")

    month sort = format(date[date],"MM")

     

    Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
    Thanks. My Recent Blog -
    Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
    Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

    Connect on Linkedin