Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
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 @v-rzhou-msft , 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:
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |