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

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

Accepted Solutions
BhaveshPatel Super Contributor
Super Contributor

Re: Table conditional cell colors

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.
4 REPLIES 4
BhaveshPatel Super Contributor
Super Contributor

Re: Table conditional cell colors

@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.
miguelflores Regular Visitor
Regular Visitor

Re: Table conditional cell colors

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,

BhaveshPatel Super Contributor
Super Contributor

Re: Table conditional cell colors

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.
miguelflores Regular Visitor
Regular Visitor

Re: Table conditional cell colors

Thanks! BhaveshPatel!

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 42 members 987 guests
Please welcome our newest community members: