Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
dgilm33
Helper I
Helper I

Clustered Column Chart graph changes when I sort the axis column by an index column

I have a clustered column chart that shows the % of sales by year for 5 categories. I'm able to get it to show the percentages accurately, as well as the legend. However I want the axis to show in a specific order. I have a index column that lists how I want the columns to be ordered, but when I sort the axis column by the index column, the entire graph changes and every clustered column shows 100%. Why would that be?

 

1 ACCEPTED SOLUTION
dhruvinushah
Responsive Resident
Responsive Resident

Based on just an holistic view of your question I can assume that the index column is not able to effectively summarize the order associated with each category. Due to the aggregation between year and also the % of sales calculation, the index column probably unhooked one of the other aggregations thus causing your second screenshot to show highest 100% to lowest 0%. 
Check any other filters, try to sort the x-axis column in the data pane using the Sort-By Field -> Index. Another sort option would be to add that Index field as a tooltip and then clicking on the elipsis of the visual and choosing the Sort By: Index field, for the visual. 
 
That is all that can be derived from what little information you have shared. Please share more information for accurate help. 

Please give thumbs up, if this helps. Thanks









View solution in original post

1 REPLY 1
dhruvinushah
Responsive Resident
Responsive Resident

Based on just an holistic view of your question I can assume that the index column is not able to effectively summarize the order associated with each category. Due to the aggregation between year and also the % of sales calculation, the index column probably unhooked one of the other aggregations thus causing your second screenshot to show highest 100% to lowest 0%. 
Check any other filters, try to sort the x-axis column in the data pane using the Sort-By Field -> Index. Another sort option would be to add that Index field as a tooltip and then clicking on the elipsis of the visual and choosing the Sort By: Index field, for the visual. 
 
That is all that can be derived from what little information you have shared. Please share more information for accurate help. 

Please give thumbs up, if this helps. Thanks









Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.