Stacked column chart - colour

[Mohan_raj_c]

Am new to power bi and trying to plot graph using stacker column chart.

My data

Date	Time	Tag	Duration	Duration_1	Hour
7/23/2019	1:01:00 PM	A			13
7/23/2019	1:02:18 PM	B	0:01:18	78	13
7/23/2019	1:02:29 PM	A	0:00:11	11	13
7/23/2019	1:02:40 PM	B	0:00:11	11	13
7/23/2019	1:02:48 PM	A	0:00:08	8	13
7/23/2019	1:03:00 PM	B	0:00:12	12	13
7/23/2019	1:03:16 PM	A	0:00:16	16	13
7/23/2019	1:04:08 PM	B	0:00:52	52	13
7/23/2019	1:06:09 PM	A	0:02:01	121	13
7/23/2019	1:06:11 PM	B	0:00:02	2	13

 I plot above value in stacked column chart and ploted for "legend" as "duration" and "Value" as "Duration_1". It shows in different colour.

Refer image "Legend as Duration"

I plot value in two colour with respect to Tag (A & B). i ploted for "legend" as "Tag" and "Value" as "Duration_1". I getting output as sum of A is ploted first and sum of B is over the  A.

Refer image "Legend as Tag"

Am looking for an output like value of A in one colour and value of B in another colour. It should plot in the order of ABABABA.

NOTE: am looking for the  format "legend" as "duration" and "Value" as "Duration_1" but value of A in unique colour (for example green) and value of B in unique colour (for example red).

--

Regards

Mohan Raj C

[v-cherch-msft]

Hi @Mohan_raj_c 

Please check below picture.If it is not your case,please explain more about your expected output.

Regards,

[Mohan_raj_c]

nHello v-cherch-msft,

Thanks for the responce. I need to stack the value(Duration_1) of A and B with respect to time. As i mention, i can stacked the value of A and B. but, output will be like multi colour. Value of A are plotted with multiple colour and value of B plotted with multiple colour.

I need an output like value of "A" have to be in green colour and value of "B" have to be in red colour. then, graph will be like green-red-green-red-green-red-green-red-green-red (A-B-A-B-A-B-A-B).

--

expected output (A-B-A-B-A-B-A-B)Which am getting with multiple colourRegards

Mohan Raj C