Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Conditional formatting not applying color as expected

I've applied conditional formatting a column that is a %. I divided the 2 columns previously, set the format to % with 2 decimals, and the color isn't applying correctly. For instance 100.00% should be green and in one row it is and one it isn't. Anything I'm missing?

 

Need Help

2 Replies

  • v-xicai's avatar
    v-xicai
    Community Support
    7 years ago

    Hi Anonymous ,

     

    Change the decimals of the divided two columns from 2 to higher place, maybe the two column value have been rounded. Or try to change the Summarization, also you can try to upgrade the Power BI Desktop to the latest version 2.68.5432.841.

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-xicai's avatar
    v-xicai
    Community Support
    7 years ago

    Hi  Anonymous ,
     
    Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

     

    Best regards
    Amy