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
asjafri
New Member
Agree
pbiideas1
New Member
Current BI tool has this feature...would be a major show stopper if BI cannot.
Beth_Schwenzfei
New Member
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.
fbcideas_migusr
New Member
I think at the very least the conditional formatting options should be on a par with what Excel currently has.
MezzaroA
New Member
it is very important to conditional formatting grid cells basing on values different than the ones contained in each cell. Voted.
suman_sundar
New Member
Power BI is useless tool, no vision what they delivering as a product... its something half-boiled product and not good enterprise.
stephanie_ye
New Member
I totally agree this enhancement should be priority.
sahilhira162
Helper I
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 Thanks
tcontrol
New Member
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
keeskuip1
New Member
I abandoned power bi in favour of excel with powerquery and powerpivot. This formatting is available in excel but not in power bi!