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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

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’
Status: Completed
Comments
wade_mcgriff
New Member
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....
fbcideas_migusr
New Member
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.
MezzaroA
New Member
It would also solve the problem of conditional formatting based on a different measure.
renatorodrigues
New Member
COLOR DIVERGING AND CONDITIONAL FORMATTING FOR DATE COLUMNS WOULD BE GREAT EITHER!
gvazquez
New Member
We need arrows, flags like in Excel 😃
jani_liimatta1
New Member
We need expressions everywhere, not only formatting. I run daily into the limitations PowerBI has.
Corinna
Frequent Visitor
Need to also be able to conditionally format based on a field that is not a measure. You should be able to conditionally format based on any field type; Text, Date, Number, Etc - this is reporting 101
Mlwegner
Advocate II
we need the ability to conditional format by column based on different values related to that column... So I want column A to have color formatting based on different criteria than column B. Currently i am only aware you can do conditional formatting on one column
pchaudhari1
New Member
Could not imagine this simple feature is unavailable when I started to use Power BI at first.
i_p_cole
New Member
I cannot understand why such a basic function in excel is not in power BI. This would be so useful