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 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. 

 

 
 

 

 

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!

     

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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

     

  • v-kelly-msft's avatar
    v-kelly-msft
    Community 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!