cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User I
Super User I

Re: Conditional formatting colour for column chart

@cfpvin If you can't see the conditional formatting (not sure why you are not able to see that option, hopefully you have the updated PBI Desktop version) then you can't have dynamic colouring for your column bars. But if you want to change to some other colour (which will be static) then you can easily do (but that is not a feasible solution). I strongly suggest you to find why you are not able to see that feature.... Also, enable all the preview features in the options and settings of PBI Desktop.... Try all the way !



Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !





Super User I
Super User I

Re: 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  linkedin-logo.png
Read my blogs on  powerbi.tips_.png

Remember to spread knowledge in the community when you can! tu.png

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors