Forum Discussion
PowerBI, Conditional Formatting for Stacked Column Chart
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
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.
3 Replies
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.
Hi Anonymous , could you share if the color shading of the stacked chart is based on conditional formatting? Thanks!
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:
