Forum Discussion

miguelflores's avatar
miguelflores
Advocate 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
    Advocate 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
      Super 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
        Advocate I
        9 years ago

        Thanks! BhaveshPatel!