Forum Discussion
Conditional Formatting on Stacked Column Chart
Hello!
I have a stacked column chart with two measures in Y-Axis, similar to this.
I was wondering if there was any way to configure conditional formatting for the column colors?
I see the option when I have only a single measure in the Y-Axis.
Thank You!
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.
5 Replies
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#M1431214If 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!
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 ,
I would also take a moment to thank OwenAuger and Ritaf1983 , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.
Best Regards,
Community Support TeamThank you for this - I will test this out!
