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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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