Forum Discussion
Conditional Formatting on Stacked Column Chart
Hi ssrinath
The Power BI interface doesn't allow conditional formatting to be set when multiple measures are added to a stacked column chart. However, if you're willing to use this "hack", you could define conditional formatting for each measure by editing the appropriate
visual.jsonfile with the PBIP format:I just tested myself with conditional formatting defined based on a measure and it worked.
Rule/Gradient-based formatting may also be possible but I haven't tested.
Hi ssrinath
Please relate to my solution include full explanation and alternative by the link:
https://community.fabric.microsoft.com/t5/Desktop/changing-color-of-stacked-column-chart/m-p/4812114/highlight/true#M1431214
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Rita,
I like the small multiple idea! Just to expand on this, I have a requirement to display actuals based on the periods that have been completed in the calendar year, and the forecast amount for the remaining year.
I would likely have two measures on the Y-Axis, and I wanted to see if there was any quick formatting options I could take advantage off.
Thank You!