ReOrder 100% Stacked Bar Chart

[Matho101]

Hi all, 

I'd like to re-order my graph below to show producers ranked per their quality performance

e.g if reordered by quality performance Producers G23 and G4 would be the first 2 producers on the column chart. Then conversely G28 would be the ranked the worst. 

Unsure on how best to approach this and whether this is possible. 

 

[v-kelly-msft · Accepted solution]

Hi @Matho101 ,

First create a column as below:

Rank = RIGHT('Table'[Producer ],LEN('Table'[Producer ])-1)

Then duplicate "Producer"column :

_Producer = 'Table'[Producer ]

Make it sort by "Rank":

And you will see:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@Matho101 , Not very clear. Check if there is an option on three dots to change sort.

Or you create 100% stacked with the stacked line visual (Create a % of subtotal measure)

Or add a line with a required measure for Sort(Rank column of Quality Performance.  And use that for sorting. Make like color same a background color so not much visible