Forum Discussion

BoostNest's avatar
BoostNest
Frequent Visitor
9 years ago

Month & Year order

Hi would appreciate some help. We are currently limited to usingt he app only not desktop so some of the other solutions don't/can't work for us.   We are trying to create a sales report that show ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

You can create a calculated column in the DateTable so the month is in the format YYYYMM

And then you can define "SortByColumn" property for the column that you want to show in your reports so that it would be sorted by this new column.

Hope this helps

Michael

 

 

 

 

BoostNest's avatar
BoostNest
Frequent Visitor
9 years ago

Thansk for your reply Michael.

 

Your suggestion looks like it is using the desktop version to solve the problem. Do you know how to correct this in the online/app version of PBI?

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    So you don't create .pbix desktop file and then Publish it to the online service?

    This is the best practice as far as I understand

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Oh, the data is fed from Xero, I see.

      So I would recommend that you use YYYYMM format for Year-Month

      This way it will order it ascending . Maybe YYYY-MM will also work for better presentation

      Michael

      • BoostNest's avatar
        BoostNest
        Frequent Visitor
        9 years ago

        Thanks again Michael for your reply, we are running OS X so am trying to get a solution without having to use windows VM.