Forum Discussion
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 onRemember to spread knowledge in the community when you can!
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!