Column Chart sorting

Hey manojk_pbi,

Create a Sort Order Column

• Add a new column to your data table with the following DAX:

Sort Order =
SWITCH(
[Category_Column],
"Budget", 1,
"Forecast", 2,
"Actual", 3,
999
)

• Go to Data view (not Report view)
• Click on your category column (the one with Budget/Forecast/Actual values)
• In the ribbon: Column Tools → Sort by Column → Select "Sort Order"
• Refresh your visual - it will now show Budget → Forecast → Actual in that exact order

• You must set the sort column in Data view, not Report view
• The sort column should contain numbers (1, 2, 3) not text
• Once set, it applies to all visuals using that column

This is the only guaranteed method that works consistently across all Power BI versions and visual types for custom sort orders.

Fixed? ✓ Mark it • Share it • Help others!

Best Regards,
Jainesh Poojara | Power BI Developer