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

Join us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered

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
mportugal
New Member
I can't find this feature anymore in the latest PowerBI release. Is it still available?
joj2
New Member
I can't find this exact feature anymore. Has it been changed/removed recently?
teresa_baral
New Member
We need formatting based upon text value of column as well.
ssaba_rashid
New Member
Please add icons in conditional formatting similar to excel Also, kindly add the features of formatting such as that available in excel for tables such as borders, coloring, headers.
prashant_andhal
New Member
I am also looking for Conditional formatting on more than 1 fields.
jkarpan1132
New Member
this is really sad. how can PBI not allow conditional formatting for text but Excel does? shameful. truly pathetic lol.
jpipkin830928
New Member
Please could we add the same functionality for conditional formatting that is possible with Excel as this would make displaying the data a lot easier on what needs to be highlighted or emphasis on certain patterns
shimano_digital
New Member
Can we please have this feature? Having to create a separate numeric field for each text field we want to format is very cumbersome. FYI Google Sheets and Excel support this out of the box (just apply conditional formatting rule such as "text contains"), so it's really puzzling why after nearly 3 years the Power BI team still hasn't delivered
pbiideas1
New Member
another of nonsensical pitfalls of Power BI - how can this be not built in after 2 years? Microsoft should pay users to use Power BI, not the other way around. what a joke.
fbcideas_migusr
New Member
Status changed to: Completed