Forum Discussion
Stacked Column Chart - gradient color based on %
Hi non23
Unfortunately, Power BI does not support conditional formatting in stacked column charts based on the measure value. This means you cannot apply a dynamic gradient color based on the percentage within the stack.
Additionally, if your visual spans across multiple dates (i.e., a timeline), using a stacked column chart is not the most effective choice from a data visualization and UX perspective. It becomes very hard to compare changes in the dominance of different sizes over time.
Instead, I recommend using a heatmap-style matrix visual — with dates as columns and sizes as rows — to visualize the relative distribution of sizes over time. This approach is much clearer and allows you to identify patterns or shifts in size dominance more easily.
(Like the one shown in my screenshot.)If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi non23
Unfortunately, Power BI does not support conditional formatting in stacked column charts based on the measure value. This means you cannot apply a dynamic gradient color based on the percentage within the stack.
Additionally, if your visual spans across multiple dates (i.e., a timeline), using a stacked column chart is not the most effective choice from a data visualization and UX perspective. It becomes very hard to compare changes in the dominance of different sizes over time.
Instead, I recommend using a heatmap-style matrix visual — with dates as columns and sizes as rows — to visualize the relative distribution of sizes over time. This approach is much clearer and allows you to identify patterns or shifts in size dominance more easily.
(Like the one shown in my screenshot.)
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.