cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Stacked column chart - colour

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

My data

Date TimeTagDurationDuration_1Hour
7/23/20191:01:00 PMA  13
7/23/20191:02:18 PMB0:01:187813
7/23/20191:02:29 PMA0:00:111113
7/23/20191:02:40 PMB0:00:111113
7/23/20191:02:48 PMA0:00:08813
7/23/20191:03:00 PMB0:00:121213
7/23/20191:03:16 PMA0:00:161613
7/23/20191:04:08 PMB0:00:525213
7/23/20191:06:09 PMA0:02:0112113
7/23/20191:06:11 PMB0:00:02213

 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

 

Legend as Duration.jpgLegend as Tag.JPG

 

2 REPLIES 2
Highlighted
Microsoft
Microsoft

Re: Stacked column chart - colour

Hi @Mohan_raj_c 

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

a1.png

Regards,

 

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: Stacked column chart - colour

nHello 

 

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)expected output (A-B-A-B-A-B-A-B)Which am getting with multiple colourWhich am getting with multiple colourRegards

Mohan Raj C

 

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors
Top Kudoed Authors