Forum Discussion

joglidden's avatar
joglidden
Advocate III
10 years ago
Solved

Conditional formatting has not been fully implemented in Power BI tables, correct?

From what I'm reading, Microsoft has not yet fully implemented conditional formatting in tables, in Power BI. I can see this is possible with a measure, but not possible with simple data in a table. ...
General Comment
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    10 years ago

    Hi joglidden,

     

    Based on my test, Conditional Formatting feature is available for measures instead of column fields in a table visual currently. For more information, please refer to "Conditional formatting in tables" section in this article: Power BI Desktop May Update Feature Summary.

     

    For your requirement, I will report it internally and will keep you updated if I get any feedback.

     

    Best Regards,
    Qiuyun Yu

ankitpatira's avatar
ankitpatira
Community Champion
10 years ago

joglidden You can do conditional formatting in power bi desktop. See below. You need to drop field onto Color Saturation area then under paintbrush icon expand Data colors and provide min max values to color code. Yes but you can't do that in tables yet.

 

joglidden's avatar
joglidden
Advocate III
10 years ago

Right, and I appreciate the response and the insight. But that's not a table, that's a graph. I need to be able to do this:

 

Which is in Access. It doesn't have to look like it, just with colors on the dates. Can't see that option when I right-click on the field.