Forum Discussion

MarkWilliamson's avatar
MarkWilliamson
Regular Visitor
9 years ago

Order By Month Year

First off, I am brand new to Power Bi.  I have already submitted one question which was answered fully by the great people on this forum.  Also, had a lot of great feedback to help me get familiar with Power BI.

 

I have yet another question I hope I can get help with.  I have a stacked column chart with a fields ReportMonthYear i.e. 'Mar-17' as my axis.  This is a 6 character field.  When i display my data the ReportMonthYear fields display in alphabetical order i.e. 'Apr-16',

'Apr-17' etc.  as opposed to displaying in month/year order. 

 

Any suggestions on how I can accomplish this ????

 

Thanks in advance to all who reply !

 

Mark 

Need Help

4 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    9 years ago

    Hi MarkWilliamson,

     

    In the modeling tab you have an option to sort the columns by another column, I don't know if you have a date column but if you do select your ReportMonthYear and on the Sort by column option select the date.

     

    Regards,

    MFelix

    • MarkWilliamson's avatar
      MarkWilliamson
      Regular Visitor
      9 years ago

      Hi MFelix !

       

      Thanks for your help !!!  When I go to the modeling tab the sort by column field in not accessable.  I must be doing something wrong.

       

      In addition, another issue I have is that I am reporting counts,  how do I make a count a negative number ?  I am assuming that i need to create a calculated field ?

       

      Again, thanks in advance for your help !!!!!

       

      Mark

      • MFelix's avatar
        MFelix
        Icon for Super User rankSuper User
        9 years ago

        Sorry for this question, but did you select the column to be sorted?

         

        Regarding the count you are correct you need to do something like:

         

        Negative count = - COUNT(Table[Column name])

         

        Regards,

        MFelix