Forum Discussion

Matho101's avatar
Matho101
New Member
5 years ago
Solved

ReOrder 100% Stacked Bar Chart

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...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    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!

     
v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
5 years ago

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!