topic Re: PowerBI, Conditional Formatting for Stacked Column Chart in Developer

PowerBI, Conditional Formatting for Stacked Column Chart

Anonymous — Sat, 05 Jun 2021 08:25:01 GMT

I'm a geologist and trying to create a "Stratigraphic Column" to visualize the progress of Drilling Rig and I realized that Stacked Column Chart is suitable for that visualization.

Everything is perfect except colors. Each lithology has their own color but PowerBI assign random colros to them. There is no any "Conditional Formatting" button in chart properties. That project is very critical for me, is there any code for that or is there any other tool to create something like Stratigraphic Column in PowerBI?

Thats what I want to create similar;

https://i.stack.imgur.com/5hkNI.png

This is my final progress in PowerBI;

https://i.stack.imgur.com/hHXWw.jpg

This is databse where I get data for chart;

https://i.stack.imgur.com/Qz5gG.jpg

Re: PowerBI, Conditional Formatting for Stacked Column Chart

Fowmy — Sat, 05 Jun 2021 15:11:56 GMT

@Anonymous

If you want to apply your own colors for each unit then you will find the Colors section in the Properties and you will be able to pick any existing color or go for More... option from there:

Re: PowerBI, Conditional Formatting for Stacked Column Chart

Anonymous — Mon, 07 Jun 2021 05:45:39 GMT

Hi @Anonymous

Power BI will divide your values in different groups by legend and show different colors by gourps.

So if you add From column in Legend, power bi will divide To column by From column and show different colors.

If you want to show different colors by lithology groups, you can add lithology column into legend instead of From column. Then Power BI will show diffrent colors by lithology groups.

Best Regards,

Rico Zhou

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

Re: PowerBI, Conditional Formatting for Stacked Column Chart

bsg009 — Wed, 25 Jan 2023 03:29:50 GMT

Hi @Anonymous , could you share if the color shading of the stacked chart is based on conditional formatting? Thanks!