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 wi...
Need Help
MFelix's avatar
MFelix
Super 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
    Super 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