Forum Discussion
Clustered Column Chart graph changes when I sort the axis column by an index column
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