Conditional formatting colour for column chart

If you have something in the legend field, you cannot use formatting.

However, I think from the picture, that you do not have anything in the axis field of your column chart.

Please put something in the axis, and check again. It can be a disassociated table with a single value if really needed. When applying custom formatting, make sure you hover your mouse over the ellipsis to make it show.

Otherwise, I suggest if you are only displaying one value, you could use a CARD visual, and format the background using the same conditional formatting found in background attributes.

If you want to show the target other options could be a KPI, GUAGE, or the custom visual CARD WITH STATES by sqlbi.

Love hearing about Power BI tips, jobs and news?
I love to share about these - connect with me!

Stay up to date on  
Read my blogs on  

Remember to spread knowledge in the community when you can!