Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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?
Solved! Go to Solution.
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
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
 
					
				
				
			
		
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
 
            | User | Count | 
|---|---|
| 84 | |
| 49 | |
| 36 | |
| 31 | |
| 30 |