combined line and stacked bar chart - separator bar / conditional formatting

[DrmedDenrasen]

Hello all,

I have two questions/problems:

1. Is there a possibility to make the barely visible white separator line in the stacked bar chart bigger / better recognizable?2.

2. Is there a way to set the colors of the individual bar elements using conditional formatting? Or better via the HEX code from the data set?

many thanks in advance!

[DrmedDenrasen]

What about the separators between the stacked bars? Is there a way to more clearly delineate the individual elements here?

[v-jianboli-msft]

Hi @DrmedDenrasen ,

Power BI does not currently support setting the separators between the stacked bars, you can only distinguish them by setting different colors for different data, and you can also add data labels

Best Regards,

Jianbo Li

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

[DrmedDenrasen]

Do you know of any custom visulas that could make this happen?

[v-jianboli-msft · Accepted solution]

Hi @DrmedDenrasen ,

Maybe you can use Clustered Stacked Column Chart

You can change the bar border width:

Best Regards,

Jianbo Li

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

[v-jianboli-msft]

Hi @DrmedDenrasen ,

According to my knowledge, your requirement could not be realized currently.

You can try to set the colors of the individual bar elements manually

Or find other similar custom visuals. 

If you also want this in  Power BI line and clustered column chart, let the power bi community to know this things and give your votes at Fabric Ideas, you may vote the idea and comment  to improve this feature. It is a place for customers provide feedback about Microsoft Fabric products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,

Jianbo Li

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