Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
joglidden
Advocate III
Advocate III

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. I add data to a table, right click, no option for conditional formatting. Sigh.

 

For instance, if a record date (just data, not a measure) is in the past, it might come up with a pink background.

 

Now I'm still using Access to produce my reports. Anyone at MS feel like getting on this one? It would be awesome.

1 ACCEPTED SOLUTION
v-qiuyu-msft
Community Support
Community Support

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
aww91
Frequent Visitor

Sorry, using version: 2.36.4434.381 32-bit (June, 2016) and still don’t see it. Please remove Solution if this feature has not been  fully implemented. Thanks

 

Yes, that is an error on my part. There is no solution. Please indicate to me how to do this, thanks. 

v-qiuyu-msft
Community Support
Community Support

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I'm still using MS Access! I really think that Power BI ought to be able to do the things that Access does. Just sayin'.

 

ankitpatira
Community Champion
Community Champion

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

 

Capture.PNG

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:

 

Capture.JPG

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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.