Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 per...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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. 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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. 

  • bsg009's avatar
    bsg009
    Frequent Visitor
    3 years ago

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