Conditional formatting (cell highligh, font, etc) when comparing multiple fields
PowerBI needs to have the ability to offer conditional formatting of based on the comparison of 2 or more metrics. For example if metric A = metric B then change the font and highlight color of the cell to red.
If metric A > metric B and metric A < metric C then change the font and highlight color of the cell to green.
This should be unlimited for how many colors can be used. Other BI tools offer this feature.
Note that this is different than what PowerBI currently calls ‘conditional formatting’
We need arrows, flags like in Excel =)
Antonio Mezzaro commented
It would also solve the problem of conditional formatting based on a different measure.
Elena Schott commented
If we can get conditional formatting based on other cells in the row available, then folks can add baby images as a cell type separately (arrow, circle, stoplight, baby chickens, whatnot) and be able to colorize them etc based on this which is needed first.
Yes, exactly, what would also be good to be able to use your own image url's in the matrix tables as values, or if the image url's could be integrated into conditional formatting interface. For a service health dashboard, you really need a matrix table with the values as the service health icons. E.G. Rows would be the name and columns would be the date, then values would be an icon set representing an outage or green checkmark, etc....
Kees Kuip commented
I abandoned power bi in favour of excel with powerquery and powerpivot.
This formatting is available in excel but not in power bi!
We need a feature that allows us to visualize some data with icons like traffic lights, flags, and arrows as in Excel. Sorry for my english but I understand a little
Can we have conditional formatting on categorical values.?
If Status column is Completed, color = Green
If status column is Running, color = Yellow
If status column is On Hold, color = Red
Antonio Mezzaro commented
it is very important to conditional formatting grid cells basing on values different than the ones contained in each cell. Voted.
Power BI is useless tool, no vision what they delivering as a product... its something half-boiled product and not good enterprise.
I totally agree this enhancement should be priority.
I think at the very least the conditional formatting options should be on a par with what Excel currently has.
What company would buy a tool like this over a proven visualization tool without doing an assessment to determine whether it had this basic functionality? #genius
Mike Trumbore commented
Basic function even in lesser tools such a Excel. Must have if we are going to adopt Power BI as standard visualization tool.
Basic capability required to support visual metric reporting. This is absolutely necessary for us.
Adnan Jafri commented
Basic capability required to support visual metric reporting.
This is absolutely necessary, especially since we have committed to moving to Power BI from our existing tools, where this feature/capability is supported.
Current BI tool has this feature...would be a major show stopper if BI cannot.
Fundamental capability available in Tableau and other tools. 2 similar requests have been logged.
For us this is a major "show stopper" as it is a feature we use extensively in other tools such as Tableau and Business Objects.
Options should also include formatting using an image file in addition to cell highlight, font color, font size.
Abdoul Bathily commented
It will be great to have this feature add to the report as it is one of the limitation compare to others Business Intelligence tools. Hope to see this feature soon.
Thanks for all the improvement done in a monthly basis.