cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
cfpvin Regular Visitor
Regular Visitor

Conditional formatting colour for column chart

Is it possible to make a column chart with measure as the value to have conditional formatting? This is how it is now.image.png

 

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
SteveCampbell Established Member
Established Member

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

11 REPLIES 11
Super User
Super User

Re: Conditional formatting colour for column chart

@cfpvin  Did you tried this way ? If not, please do and post any questions.

 

image.png



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

Proud to be a Datanaut !





cfpvin Regular Visitor
Regular Visitor

Re: Conditional formatting colour for column chart

@PattemManohar 

Infortunately I am not getting a conditional formatting button. This is how it looks like for meimage.png

Super User
Super User

Re: Conditional formatting colour for column chart

@cfpvin  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)

 

image.png



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

Proud to be a Datanaut !





cfpvin Regular Visitor
Regular Visitor

Re: Conditional formatting colour for column chart

@PattemManohar 

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?

 

  image.png

Super User
Super User

Re: Conditional formatting colour for column chart

Hope you are checking that under “Data Colours” as per the screenshot in above post.


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

Proud to be a Datanaut !





Anonymous
Not applicable

Re: Conditional formatting colour for column chart

What version of Power BI you're using? Please upgrade to the latest.
Cheers!
Super User
Super User

Re: Conditional formatting colour for column chart

@Anonymous I guess his PBI version will be recent version, as we can see light background in the Screenshot of the Format pane (which was the update in recent releases)

Anyway, @cfpvin please confirm which version of PBI desktop you are using.


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

Proud to be a Datanaut !





Super User
Super User

Re: Conditional formatting colour for column chart

@cfpvin  Here is another screenshot which might help you...

 

image.png



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

Proud to be a Datanaut !





cfpvin Regular Visitor
Regular Visitor

Re: Conditional formatting colour for column chart

image.png @PattemManohar  I looked in data colours but there is no button. What would be another solution?


@PattemManohar wrote:

@cfpvin  Here is another screenshot which might help you...

 

 


 

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 197 members 2,456 guests
Please welcome our newest community members: