Forum Discussion

PowerBIGuy1's avatar
PowerBIGuy1
Frequent Visitor
9 years ago
Solved

Conditional Formatting in Table Visualization

I am using latest Power BI desktop version (Version: 2.42.4611.901 64-bit (January 2017)).

 

I could not find conditional formatting option in Table Visualization. I can do regular formatting on row/column level. I found some forum threads and articles but they seems to be 3 months old etc. I wonder if conditional formatting is done differently or disappeared in latest version?

 

I want to color a value or change background of a cell, If a value is above 100 in a column.

 

Need Help
  • parry2k's avatar
    parry2k
    9 years ago

    I have the latest release and conditional formatting is there. You can add condition formatting on number columns (fields), make sure that is what you are doing.

     

11 Replies

  • parry2k's avatar
    parry2k
    Super User
    9 years ago

    I have the latest release and conditional formatting is there. You can add condition formatting on number columns (fields), make sure that is what you are doing.

     

    • PowerBIGuy1's avatar
      PowerBIGuy1
      Frequent Visitor
      9 years ago

      I was trying it on a string column. But i think just having it on number column works for now.

      Another scenario that I have is to color code a column value if we find certain keywords in a text column. Operators adds comment, We want to highlight some important comments based on URGENT keyword in the value. I figured out other ways to do it by finding it using a measured column and then color code based on measured column value etc.

    • AndrewDang's avatar
      AndrewDang
      Helper IV
      9 years ago

      I am using the latest version of Power BI and I DON'T see the Conditional Format option. I am not sure what was wrong. I tried on all fields, incluidng text and number.

       

      Could you please help.

       

      Thanks;

      Andrew