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.

 

Thanks,

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.

     

4 Replies

    • 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.