Forum Discussion

bebeto's avatar
bebeto
Helper III
9 years ago
Solved

Table conditional formatting

Hi,

 

I have the Power BI Desktop Version: 2.43.4647.541 32-bit (febrero de 2017)

 

And I can't see the option Conditional Formatting in the table values... Before updating the version I could see it, does this version change this feature or am I doing something wrong?

 

Thanks!

  • Hi bebeto,

     

    No. Unfortunately, this is not a supported functionality right now.

     

    Regards,
    Yuliana Gu

6 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    Hi bebeto,

     

    The 'Conditional Formatting' option is still available in version: 2.43.4647.541 (Feb 2017). But this option only applies to aggregated values or measures. Otherwise, it is disable if you don't summarize the value field.

     

    Best regards,
    Yuliana Gu

    • bebeto's avatar
      bebeto
      Helper III

      Thanks v-yulgu-msft,

       

      So, can I apply conditional formatting to change de font color of a text column if the condition is Column = "Hello"?

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Microsoft Employee

        Hi bebeto,

         

        No. Unfortunately, this is not a supported functionality right now.

         

        Regards,
        Yuliana Gu

  • Hey

     

    I found a workaround for this. First, choose an aggregated function for example Sum (even though you might not need to do this function). Then apply the conditional formatting for this field. After that remove the function by checking "don't summarize option" when clicking right by the name of the field on the visualization navigation bar. Amazingly, it keeps the conditional formatting. 

     

    Check it out :) 

  • sreenu's avatar
    sreenu
    Regular Visitor

    Hi bebeto,

     

    The 'Conditional Formatting' option is available only aggregated values or measures.Otherwise, it is disable if you don't summarize the value field.

     

    Thanks,