Forum Discussion
Sort by Column on a table
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?
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'
3 Replies
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'
Hi, I'm not sure the sort you are looking for but I believe this peace of doc can help:
Regards,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Is this problem solved?
Best Regards,
Icey
