marcelo on 21 Aug 2015 09:07:01
It was implemented in charts but not in tables or matrixes.
Administrator on 31 May 2016 23:23:27
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/.
- Comments (166)
RE: conditional formatting in tables
I agree with the comments here, we should have this available. Furthermore the formatting options should be flexible and apply to single column, rows or cells depending on the visualization used.
In my example I can think of, I'd like to use the Card Visualization and be able to format the colour of the percentage number displayed there based on whether that number is > 0 or < 0
RE: conditional formatting in tables
This is a very important feature and I am surprised that there is such low number of votes as almost every Excel user uses conditional formatting in tables.
RE: conditional formatting in tables
In particular, changing the column names when you apply aggregations, since PowerBI automatically changes those for you to "Average of", "Max of", etc. And that may not be exactly what you want!
RE: conditional formatting in tables
'@Will Thompson, Yes that would be very useful. Please do both!
RE: conditional formatting in tables
It will be great also to group fields in a hierarchy
RE: conditional formatting in tables
Yeah, mandatory.
RE: conditional formatting in tables
As Samuel V said something similar to color saturation would work, the ability to color based on certain values is critical for power bi
RE: conditional formatting in tables
Please add Conditional Formatting and also +/- Expand/Collapse buttons in the Matrix Visualization.
RE: conditional formatting in tables
There are two separate features at work here, and each feature is important:
1) Color by Value (Color Saturation). E.g. value axis by sales and color by profit.
2) Conditional Formatting. Similar to formatting an Excel range based on specified criteria. If color saturation is on for the chart, conditional formatting overrides the color for certain data points.
RE: conditional formatting in tables
Having the conditional formatting behave similarly to excel, or to KPI indicators would be great, but it needs to work on the cell level, and needs to support two color gradients and red-yellow-green.