Sort by Column on a table

[Anonymous]

I have create a report that uses a tabular.  The report lists the months as columns and the sales as values.  A calculation has been created (Offset Month) in the tabular model that works out the offset for each month and provides and ID e.g. Jan = 1, Feb = 2.  I want the report to be ordered by the Offset Month field and not be displayed on  the report.  Is this possible?

[Icey]

Hi @Anonymous ,

Is this problem solved?

Best Regards,

Icey

[ibarrau]

Hi, I'm not sure the sort you are looking for but I believe this peace of doc can help:

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column#sort-using-the-sort-by-column-butto...

Regards,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DS12345 · Accepted solution]

Hi @Anonymous ,

Yes, it is possible to sort a column by another column. You can do so in the 'Data' section of Power BI desktop. 

- Select the column you want sorted (in your case: Month Name)

- Click 'Sort by Column' in the ribbon under 'Modeling' 

- In your case choose column 'Offset Month'