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!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I want to reorder my Inventory status first to show Below Min, Normal, and then Above Max.
I wish I could just drag and reorganize. 😞
Can someone help me please?
Solved! Go to Solution.
Create a new Table (i.e. using Enter Data is probably easiest ) to create an Inventory Status table:
| Status | Order |
| Below Min | 1 |
| Normal | 2 |
| Above Max | 3 |
Join this table to your Fact table.
Then use the Sort by Column in the Column Tools menu to sort your Status by the Order column.
Regards,
Create a new Table (i.e. using Enter Data is probably easiest ) to create an Inventory Status table:
| Status | Order |
| Below Min | 1 |
| Normal | 2 |
| Above Max | 3 |
Join this table to your Fact table.
Then use the Sort by Column in the Column Tools menu to sort your Status by the Order column.
Regards,
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!