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!
Anonymous Did you tried this way ? If not, please do and post any questions.
Infortunately I am not getting a conditional formatting button. This is how it looks like for me
Anonymous There will be a small ellipse button on the right side as shown below (it looks like hidden, may be due to the light background as well)
Unfortunately I do not have the button. I clicked near that area many times to see if there is one but there isn't. Is there another way?
- Hope you are checking that under “Data Colours” as per the screenshot in above post.