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
Hi Guys,
Please bear with me here , as simple as it sounds it seems like a difficult task,
I am trying to order the item column in ascending order for the same towermodelID
When I try to sort by column here as below:
I get the following error:
Could Somebody please help me to sort the item column in ascending order for the same towermodel ID ?
Solved! Go to Solution.
Hi @Anonymous,
If it is no problem for you that [TowerModelID] will be sorted in ascending order as well, you can the following:
- go to PowerQuery (Transform Data);
- sort [TowerModelID] somehow;
- press SHIFT and select [Item];
- sort [Item] in ascending order;
- save changes.
After that sorting of [TowerModelID] and [Item] should be synchronized in Table View: if you sort [TowerModeID] in descending order, [Item] will be sorted in the same order and vice versa.
Best Regards,
Alexander
Hi @Anonymous,
If it is no problem for you that [TowerModelID] will be sorted in ascending order as well, you can the following:
- go to PowerQuery (Transform Data);
- sort [TowerModelID] somehow;
- press SHIFT and select [Item];
- sort [Item] in ascending order;
- save changes.
After that sorting of [TowerModelID] and [Item] should be synchronized in Table View: if you sort [TowerModeID] in descending order, [Item] will be sorted in the same order and vice versa.
Best Regards,
Alexander
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 35 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 134 | |
| 96 | |
| 78 | |
| 67 | |
| 65 |