Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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).
--
Regards
Mohan Raj C
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.