Stacked Graph Help Please

[Pricey79]

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 have the red which is late, always be on top rather than the middle please?

Thank you in advance 

[Anonymous · Accepted solution]

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.

[Pricey79]

@Anonymous You are an absolute star, that works perfectly.  Thank you so much for your time sir. 

[vanessafvg]

firstly what format is your data in, very hard to know how to sort it without understanding how you have modelled your data please provide a pbix or some data in text form or a view of how your data looks

[Pricey79]

@vanessafvg Thank you for your reply. 

Apologies but I'm a novice at this, exactly which data would you need to see? 

[vanessafvg]

the data in the graph, what does the table look like is it all from one table?  can you copy and paste some of the values in text form?  really hard to help with the information you have given.

basically you either need to share your pbix or share some fo the data or sample data in text form. read this post on how to provide sample data, that will help https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/2001860#M7544...

[Pricey79]

@vanessafvg Thank you

It's all in one table that comes from a sharepoint list , in one column

Each row is a unqiue number, and then their is a count on the number of unique numbers

Does that help at all?

Sorry to be a pain

[vanessafvg]

no it doens't help because i dont know whats in your data

go to the table view  and screenshot the table that has the data in it,

then i need a screenshot of the visual as you provided above but including what fields are placed where on the visual

[Pricey79]

@vanessafvg Thank you

Here are the screenshots: