stacked bar chart reorders x axis

[Gualjohn]

I have a stacked bart chart showing productivity by person (x  Axis) by day (y axis stacked) for a one week period.  My source data has a column for total weekly producivity which I use to sort in decending order, with the intent of ordering the x axis in decending level of weekly performance.

The visualization insists on reordering the x axis by alphabetizing the names.  Can I work around this in some way?

[v-jiascu-msft]

Hi @Gualjohn,

Could you please mark the proper answers as solutions?

Best Regards,

Dale

[Gualjohn · Accepted solution]

Firstly, my apologies, I had thought I replied to this.  In your example, the first column on the left should become black, then white, then silver etc.  For me, the X - Axis stayed in alphabetic order, regardless of the sort, and regardless of the fact that I had ordered the rows in excel prior to opening Power BI.  My solution was to add a ranking number in front of the name in excel:  ex: 1. Black, 2. White, 3. Silver etc.  

[v-jiascu-msft]

Thanks for sharing, @Gualjohn. You really have the solution for your scenario.

Best Regards,
Dale

[v-jiascu-msft]

Hi @Gualjohn,

It seems you mean the Stacked Column Chart. Please refer to the snapshot below. You can do it like that. If you still can't achieve it, please share a sample file. Please mask the sensitive parts first.

Best Regards,
Dale