cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
miguelflores
Advocate I
Advocate I

Table conditional cell colors

Hello,

 

Is there a conditional cell colors in power bi? Where do I find it?

Here's what I want to happen:

I have a certain target and if that target was not achieved, cell color should be red.

 

Thanks,

1 ACCEPTED SOLUTION

You should have an aggregated data (SUM, COUNT etc.) to activate the conditional formatting option.

 

see the attacheed screenshot.

 

cond.PNG

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

View solution in original post

4 REPLIES 4
BhaveshPatel
Community Champion
Community Champion

@miguelflores

 

Please refer to the DOCUMENTATION explained here.

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

Hi @BhaveshPatel,

 

Thanks!

But, there's no conditional formatting option when I right-click the field I want to put a contional formatting to.

 

Capture.PNG

 

Thanks,

You should have an aggregated data (SUM, COUNT etc.) to activate the conditional formatting option.

 

see the attacheed screenshot.

 

cond.PNG

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

View solution in original post

Thanks! BhaveshPatel!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors