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!

     
amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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