Coloring scheme bars from stacked column graph not possible with grouped columgraph?

[Namoh]

Hi.

I've created a graph based on a stacked column graph (visuals, top row, 2nd from the left), see picture 1.

I've customized the colors of the bars via setup (paintroller), see picture 2.

Now they want to add next to the actuals also some target figures.

I did this by changing the graph type into linegraph and stacked column graph (visuals, 2nd row from top, 4th from the left).

But this visual is not looking very nice, see picture 3.

So I changed the graph type into grouped column graph (visuals, top row, 4th from the left).

It automatically changed all bars into 2 different colors, one for each dataset.

When I wanted to change the colors again as before, I don't have this option anymore.

I can only give each dataset a color, not specific bars anymore, see picture 4.

Is this possible with this type of chart, if yes, how do I do this?

If no, is there another chart type that I should use that can give me the same (kind of) visualisation but with the option to change colors from individual bars.

[v-zhenbw-msft]

Hi @Namoh ,

How about the result after you follow the suggestions mentioned in my original post?

Could you please provide more details or expected result about it If it doesn't meet your requirement?

If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly.

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-zhenbw-msft]

Hi @Namoh ,

If you put field in legend, the Data color only has the legend field.

So if you want to change the color of a particular column, don't put some fields in Legend.

Then you can configure the color using Show all funciton.

For specific settings, please refer to this document.

https://docs.microsoft.com/en-us/power-bi/visuals/service-tips-and-tricks-for-color-formatting

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Namoh]

Hi v-zhenbw-msft, thanks for your input.

I've checked but I don't have anything in the Legend?

But still I don't get the option "Show all"?

See picturs below.

Am I looking at the wrong stuff ...?

[v-zhenbw-msft · Accepted solution]

Hi @Namoh ,

Sorry for that if there are two fields in Values, it cannot change each column color.

There is a method you can refer.

Create two column chart, turn off the background of one Column chart and put it on another column chart.

BTW, you need to configure the Start and End.

If it doesn’t meet your requirement, perhaps you can submit the requirement to ideas and add your comments there to make this feature coming sooner : https://ideas.powerbi.com/forums/265200-power-bi-ideas

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Namoh , once you use a legend , conditional formatting is not possible.

Please vote for ideas on this topic at https://ideas.powerbi.com/ideas/ . Or create a new idea