Forum Discussion

Pricey79's avatar
Pricey79
Helper V
5 years ago
Solved

Stacked Graph Help Please

Hello. I was hoping someone could help me please.   I have the below graph (100% stacked column) with three colours for three sets of data: Early, On Time and Late     Is it possible to ha...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Pricey79 ,

     

    You can try to sort the field in Lengend.

    [Hit/Miss] is a column that contains three attributes: LATE, ON TIME and EARLY, right?

     

    First, you need to create table by entering data as follows

    Then select the TYPE column and sort by the sort column.

    In my example, I use it to connect [ctbr_type], you can judge the connection of your relationship according to the specific situation.

     

    Finally, you can see that LATE is at the top instead of in the middle. Because Power BI sorts by the first letter of the text by default, LATE is in the middle.

    The field used in Legand is the TYPE column in the new table.

     

    You can check more details from the attachment.

     

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.