Forum Discussion
Stacked column chart - colour
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
2 Replies
Hi Mohan_raj_c
Please check below picture.If it is not your case,please explain more about your expected output.
Regards,
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
