conditional formatting in tables
It was implemented in charts but not in tables or matrixes.
We released conditional formatting in tables with our May release of Power BI Desktop. Give it a try and let us know what you think. You can learn more about how to use it in our latest blog post: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-update-feature-summary/.
Doesn't format the Total value.
Salvatore Cagliari commented
I have the problem that it doesn't work when only one row is in the table.
As already mentioned here.
Why conditional formatting on tables are not working if there is only one row?
As others have stated, I would also not consider this complete. True conditional formatting, as you know from your product Excel, should allow for highlight one or more cells based off of cell value or ranges. Providing a gradient off of minimum and maximum is truly not valuable.
Does Conditional Formatting applied to total value of that column or not?
Is that feature is available in Power BI desktop?
Marcus Mattson commented
same as the "entire row" comments preceding this comment.
Ditto to Scott A below. Conditional Formatting in tables is not complete by any means.
Scott A commented
This is not complete by any stretch of the imagination. I do not want GRADIENTS in my conditional formatting. I just want any value over 25 to show up as red... not all sorts of shades of red starting BELOW 25 and higher. Ridiculous implementation of a standard and basic feature.
When I right clicked on value the conditional formatting option did not appear - also it would be awesome if I could format an entire row based on one cell value - I am using as a forecast report from CRM and want commit to be green, upside yellow, all others none
Eric McGowan commented
Power BI needs conditional formatting closer to Excel. I would like to format by text entries such as "contains" or "starts with"
This implementation severely lacking functionality. For example, I want to use 5 particular colors that are part of my company's design standards. Not possible as I see it.
Is there an option to conditionally format the whole row of a table visualization and not just the cell on which the condition is based on? Also, how do one turn on or off the totals.subtotals in a matrix or table chart?
Agree that this should not be marked complete. There are many other types of conditional formatting that are not available.
Kees Kuip commented
Please consider marking this as not completed because it is much to basic for my needs.
Ik need to format cells dependend on other measures
Need to be able to do conditional formatting on rows...
José Pintor commented
When can we expect have the possibility to format conditionally rows in tables or matrixes?
I still seeing it only available in charts!
Kelly Hurtado commented
Please update this functionality. I want the same kind of options I have in Excel. Right now, I mainly need to highlight values that are negative. This should be available.
Øystein Aas commented
I think this feature is not as good as it could be.
I - as many others have requested - am looking into conditionally formatting an entire row based on the value of one column, that does not necessary need to be shown in the table at all. Example: We use tables to give in-depth information about our deviations. The deviations have levels of severity, but we do not show this level in the table. Howerver it would be very visual and useful to use conditionally formatting to highlight the severity without including the specific level of severity.
Is it possible to conditionally format full rows in a table (not just specific columns) based on the value of a particular column - which may not even appear in the table?
Please update this functionality. It is so basic, and will not fit our needs. For example, we have very specific color for project status, like, blue for completed, green for active, yellow for concerned, red for over due...etc. But, there is no way I can find to code like this! The closest thing is "conditional formatting for measurement" which I can only specific 3 colors at the most...