Forum Discussion
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 have the red which is late, always be on top rather than the middle please?
Thank you in advance
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.
8 Replies
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.
Anonymous You are an absolute star, that works perfectly. Thank you so much for your time sir.
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
vanessafvg Thank you for your reply.
Apologies but I'm a novice at this, exactly which data would you need to see?
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#M754454
