Define fixed colours for legend

Question

Hello,I have the following table in Power Query and the data is shown in a stacked column chart visualization in Power BI with the legend showing a different colour for each city. The problem is when the data is refreshed or when a city is added or removed, the colour for the other cities change randomly. Is there a way to set specific colours for each city automatically? Maybe a conditional column or some other way to assign a city to a specific number which would equal to a specific colour? Is this possible? Any help is much appreciated!&nbsp;DateTurkeyMoscowLondonSaint PetersburgBerlinMadridKievRomeParisBucharestMinskViennaBudapestHamburgWarsaw03/01/2022nullnull161171591568296588null8815nullnull10/01/2022nullnull161221591576326589null8819nullnull17/01/2022nullnull161231681694247086null9014nullnull24/01/2022nullnull141261721670285891null9813nullnull31/01/2022nullnull111081741272276688null9211nullnull07/02/2022nullnull16871781470325793null9612nullnull14/02/2022nullnull16691741577316089null9314nullnull21/02/2022nullnull15671661376286686null7812nullnull28/02/2022nullnull15841661559327592null9315nullnull07/03/2022nullnull16571871767297083null9614nullnull14/03/2022nullnull15461721477286691null9917nullnull21/03/2022nullnull15471791589317887null8716nullnull28/03/202224null15531761491287385null8919nullnull04/04/202224null14811771576257188116821778null11/04/20223null161181821566296387135931483null18/04/2022201815142172226529759413793null120null25/04/202215151316516287130789513286null119null02/05/2022162116167150168029739112997null125null09/05/20222117151681691672297193129100null130null16/05/2022291716171168167032769112797null132null23/05/20222614151691811282327592125102null133null30/05/2022281816175177148331759013199null126null06/06/2022321815178175148726789013399null128null13/06/2022281615175184159431709013494null129null20/06/2022261616176182169132739112290null132null27/06/2022231513182195168432689412788null115null04/07/2022321515181198168331659412892null114null11/07/2022351512181194168132608713289null125null18/07/202235149180192168430628913179null127null25/07/2022301512171210168032658213787null121null01/08/2022201614179234138232658412292null118null08/08/2022222013179226168232769011596null117null15/08/2022231813179226168532779011696null117null22/08/20222519111782391478308092127104null108null29/08/20222719131722311690297989119105null91null05/09/202225202283255148531808812092null1045212/09/2022252222100260148529779312482null11848&nbsp;Currently, the only way that i can solve this is by manually going through the list below and setting the colour for each city.&nbsp;

amitchandak · Answer

Anonymous , You Can not do conditional formatting for the legend as of now 
&nbsp;
You can log an idea - https://ideas.powerbi.com/ideas/

Forum Discussion

Define fixed colours for legend

1 Reply

Related content

un define

Changing colours of legends

Dynamic legend colours

Legend colour issue on Combo chart

Dynamic Legend colours in Stacked column chart

Date	Turkey	Moscow	London	Saint Petersburg	Berlin	Madrid	Kiev	Rome	Paris	Bucharest	Minsk	Vienna	Budapest	Hamburg	Warsaw
03/01/2022	null	null	16	117	159	15	68	29	65	88	null	88	15	null	null
10/01/2022	null	null	16	122	159	15	76	32	65	89	null	88	19	null	null
17/01/2022	null	null	16	123	168	16	94	24	70	86	null	90	14	null	null
24/01/2022	null	null	14	126	172	16	70	28	58	91	null	98	13	null	null
31/01/2022	null	null	11	108	174	12	72	27	66	88	null	92	11	null	null
07/02/2022	null	null	16	87	178	14	70	32	57	93	null	96	12	null	null
14/02/2022	null	null	16	69	174	15	77	31	60	89	null	93	14	null	null
21/02/2022	null	null	15	67	166	13	76	28	66	86	null	78	12	null	null
28/02/2022	null	null	15	84	166	15	59	32	75	92	null	93	15	null	null
07/03/2022	null	null	16	57	187	17	67	29	70	83	null	96	14	null	null
14/03/2022	null	null	15	46	172	14	77	28	66	91	null	99	17	null	null
21/03/2022	null	null	15	47	179	15	89	31	78	87	null	87	16	null	null
28/03/2022	24	null	15	53	176	14	91	28	73	85	null	89	19	null	null
04/04/2022	24	null	14	81	177	15	76	25	71	88	116	82	17	78	null
11/04/2022	3	null	16	118	182	15	66	29	63	87	135	93	14	83	null
18/04/2022	20	18	15	142	172	22	65	29	75	94	137	93	null	120	null
25/04/2022	15	15	13	165	162	8	71	30	78	95	132	86	null	119	null
02/05/2022	16	21	16	167	150	16	80	29	73	91	129	97	null	125	null
09/05/2022	21	17	15	168	169	16	72	29	71	93	129	100	null	130	null
16/05/2022	29	17	16	171	168	16	70	32	76	91	127	97	null	132	null
23/05/2022	26	14	15	169	181	12	82	32	75	92	125	102	null	133	null
30/05/2022	28	18	16	175	177	14	83	31	75	90	131	99	null	126	null
06/06/2022	32	18	15	178	175	14	87	26	78	90	133	99	null	128	null
13/06/2022	28	16	15	175	184	15	94	31	70	90	134	94	null	129	null
20/06/2022	26	16	16	176	182	16	91	32	73	91	122	90	null	132	null
27/06/2022	23	15	13	182	195	16	84	32	68	94	127	88	null	115	null
04/07/2022	32	15	15	181	198	16	83	31	65	94	128	92	null	114	null
11/07/2022	35	15	12	181	194	16	81	32	60	87	132	89	null	125	null
18/07/2022	35	14	9	180	192	16	84	30	62	89	131	79	null	127	null
25/07/2022	30	15	12	171	210	16	80	32	65	82	137	87	null	121	null
01/08/2022	20	16	14	179	234	13	82	32	65	84	122	92	null	118	null
08/08/2022	22	20	13	179	226	16	82	32	76	90	115	96	null	117	null
15/08/2022	23	18	13	179	226	16	85	32	77	90	116	96	null	117	null
22/08/2022	25	19	11	178	239	14	78	30	80	92	127	104	null	108	null
29/08/2022	27	19	13	172	231	16	90	29	79	89	119	105	null	91	null
05/09/2022	25	20	22	83	255	14	85	31	80	88	120	92	null	104	52
12/09/2022	25	22	22	100	260	14	85	29	77	93	124	82	null	118	48