Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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?
Solved! Go to 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'
Hi @Anonymous ,
Is this problem solved?
Best Regards,
Icey
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.
Happy to help!
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'
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 35 | |
| 34 | |
| 31 | |
| 28 |
| User | Count |
|---|---|
| 136 | |
| 102 | |
| 68 | |
| 66 | |
| 58 |