March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet 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
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.
Solved! Go to Solution.
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
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.
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
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'.
@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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
121 | |
98 | |
86 | |
69 | |
61 |
User | Count |
---|---|
138 | |
121 | |
109 | |
99 | |
96 |