100% stacked bar chart - sort of text column by index with same colors in legend

[Bu__]

Hi,

I  want to create a 100 % stacked bar chart which has  data like below

Ticket	Created	Time spent	state	Index
id 1	10/24/2023 16:49	1	P4	1
id 1	10/24/2023 17:23	0	P4	1
id 1	10/24/2023 17:40	1	P2	2
id 1	10/24/2023 18:02	0	P2	2
id 1	10/24/2023 18:07	0	P2	2
id 1	10/24/2023 18:10	0	P2	2
id 1	10/24/2023 18:38	0	P2	2
id 1	10/24/2023 18:49	0	P3	3
id 1	10/24/2023 18:50	13	P3	3
id 1	10/25/2023 7:13	0	P3	3
id 1	10/25/2023 7:18	0	P3	3
id 1	10/25/2023 7:21	1	P3	3
id 1	10/25/2023 8:20	0	P3	3
id 2	10/24/2023 16:49	1	P4	1
id 2	10/24/2023 17:23	0	P4	1
id 2	10/24/2023 17:40	1	P2	2
id 2	10/24/2023 18:02	0	P2	2
id 2	10/24/2023 18:07	0	P2	2
id 2	10/24/2023 18:10	0	P2	2
id 2	10/24/2023 18:38	0	P2	2
id 2	10/24/2023 18:49	0	P3	3
id 2	10/24/2023 18:50	13	P3	3
id 2	10/25/2023 7:13	0	P3	3
id 2	10/25/2023 7:18	0	P3	3
id 2	10/25/2023 7:21	1	P3	3
id 2	10/25/2023 8:20	0	P3	3

in y-axis=Ticket, x-axis=Time spent, legend=Index, but this legend does not give the same colors for all state in a id. Also, tried sorting column  state using Sort by column index which gives an error such as"there can't be more than one value in index for the same state". Would really be helpfull if there's a way to sort state by index and it should have same colors for all ticket id.

Please Note: The legend has to be sorted by index+it should same colors for every state in each id as well well over all other id's.

Thanks for your help in advance

[Bu__]

@ValtteriN , if you turn off legend and switch on custom label and put state there, you can observe that color for each state is different because of the sequence/index. Thus i want the sequence+same colors, is this possible in dax to have it sorted and  assign colors same colors to states and put this as a legend?

[ValtteriN]

Hi,

Could you add an image of the issue? Generally speaking the color should be the same between the columns since you can adjust it on series level: