Skip to main content

Power BI

Planned

Conditional Formatting for Text

Vote (4703) Share
Power BI User's profile image

Power BI User on 09 Nov 2017 03:18:20

It would be great to conditional format a table and/or a matrix based on the cell text, not only numbers

Administrator on 20 Jul 2024 20:49:20

This month we added the ability to format text fields based off a numeric field: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2018-feature-summary/#conditionalFormatting We also are planning on adding a feature that will let you format your text based on comparisons. I'll update this idea based on our progress on that feature.

Comments (151)
Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 23:15:43

RE: Conditional Formatting for Text

Agreed

Power BI User's profile image Profile Picture

Jesus on 05 Jul 2020 23:14:28

RE: Conditional Formatting for Text

and not only from cells text, we need the posibility to select a value from query or table

Power BI User's profile image Profile Picture

Billy on 05 Jul 2020 23:14:08

RE: Conditional Formatting for Text

Agreed. This seems well overdue for this product.

Power BI User's profile image Profile Picture

WVanpeel on 05 Jul 2020 23:11:10

RE: Conditional Formatting for Text

Unbelievable this is not yet possible. We try to switch our users to PowerBI from our legacy reporting tool but with lot of functionality we have to tell them... its not (yet) possible. It feels like going backwards.

Power BI User's profile image Profile Picture

James Midgley on 05 Jul 2020 23:07:59

RE: Conditional Formatting for Text

The ability to conditionally format text in a table is more important than supporting this for numbers. I find it inexplicable that you would release such a half baked feature particularly when this is something so easily achieved in Excel.

Power BI User's profile image Profile Picture

Tom Hawthorn on 05 Jul 2020 23:07:03

RE: Conditional Formatting for Text

Imagine a matrix with rows representing some list of systems, and a column which displays pass/fail or perhaps operational/non-operational. I want to show good rows as green, bad rows as red. One simple way to do this would be to allow conditional formatting for a cell on any value in the row, even values that aren't displayed. I could create a calculated column which is a number like zero or one. Then I could format "pass" as green if the hidden value is 1, or red for 0.

Power BI User's profile image Profile Picture

Alison Wright on 05 Jul 2020 23:06:46

RE: Conditional Formatting for Text

This is essential for me as a data analyst in a school where we use alphanumeric grades. In a matrix I am limited to conditional formatting only if all values in the matrix are numbers - seems crazy. I\d like to be able to conditionally format values in one field based on the value in another

Power BI User's profile image Profile Picture

TAylor on 05 Jul 2020 22:58:42

RE: Conditional Formatting for Text

PLEASE DO THIS!!!!

Power BI User's profile image Profile Picture

Jesse Glidden on 05 Jul 2020 22:57:52

RE: Conditional Formatting for Text

Really wish you geniuses could get on this one. It can't be that hard. Both for regular tables as well as a Matrix.

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 22:55:10

RE: Conditional Formatting for Text

Is there a way to conditional format a card?
I need to display a value, if the number is less than 50%, I need to set the background to red, otherwise green.

Merged Idea (2)