Forum Discussion

miguelflores's avatar
miguelflores
Icon for Advocate I rankAdvocate I
9 years ago
Solved

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. ...
Need Help
  • BhaveshPatel's avatar
    BhaveshPatel
    9 years ago

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

     

    see the attacheed screenshot.

     

miguelflores's avatar
miguelflores
Icon for Advocate I rankAdvocate I
9 years ago

Hi BhaveshPatel,

 

Thanks!

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

 

 

Thanks,

BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
9 years ago

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

 

see the attacheed screenshot.

 

  • miguelflores's avatar
    miguelflores
    Icon for Advocate I rankAdvocate I
    9 years ago

    Thanks! BhaveshPatel!