Forum Discussion
Solved
Clustered column chart - random column colors
Hi all, First post here. Hopefully anyone can be of help. In my report, I am using a Clustered column chart with 2 columns per item. Each column represents a specific date. The underlying d...
Hi Stino
What you're seeing is expected behavior for column charts with legends - colors are assigned per series, not based on which values are currently visible or their order. A workaround is to assign fixed legend values, like 1 for the latest date and 2 for the previous one. Then, hide the legend and create a matrix visual styled to resemble a legend, using a DAX-generated SVG for custom conditional formatting. This gives the impression that colors are applied dynamically based on visible dates. However, the illusion breaks when you hover over the actual column chart as you will see the actual legend value.
Please see the attached pbix.
