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 sales by month in order from April through to March as march is the end of our financial year. We can get all the correct months in the financial year but not the order as the report currently either starts at Jan-17 and finishes in Dec-2016.

 

 

By changing the sort order, all it seems to do is reverse the order.

 

Can anyone help or give me some suggestions? The data is automatically fed from a Xero Dataset.

Need Help

7 Replies

  • 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