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 06 Jul 2020 00:07:13

RE: Conditional Formatting for Text

Please update. Tableau has had this functionality for years. I really saddens me that Power BI doesn't have this capability yet. Please prioritize.

Power BI User's profile image Profile Picture

Power BI User on 06 Jul 2020 00:06:50

RE: Conditional Formatting for Text

This is badly needed... I need to have a table cell turn green if true and red if false. It looks like you have everything in place already, not sure why simple text value match is not already in the software.

Power BI User's profile image Profile Picture

JJ Malloy on 06 Jul 2020 00:06:33

RE: Conditional Formatting for Text

Any updates on this?

Power BI User's profile image Profile Picture

Power BI Ideas Admin on 06 Jul 2020 00:04:57

RE: Conditional Formatting for Text

Planned since May, 2018?

Power BI User's profile image Profile Picture

Christopher Baker on 06 Jul 2020 00:04:41

RE: Conditional Formatting for Text

Lets get this done. Easy fix Excel already has rules like this.
#LFG

Power BI User's profile image Profile Picture

Mark on 06 Jul 2020 00:04:40

RE: Conditional Formatting for Text

Yes please - conditional formatting on text values would appear to be basic funtionality

Power BI User's profile image Profile Picture

Power BI User on 06 Jul 2020 00:04:37

RE: Conditional Formatting for Text

It's in Excel, why isn't it in here? Seems pretty basic if you ask me...

Power BI User's profile image Profile Picture

Jacob Andersen on 06 Jul 2020 00:02:11

RE: Conditional Formatting for Text

We have a financial report layout table where we setup the complete custom structure with headers, line spacing etc. Then use DAX to map to the reporting items (e.g. Revenue, COGS etc.). In Excel Pivot Tables I can easily manually set the e.g. "Total Revenue" line to be bold and larger font size. I imagine this feature would enable similar reporting in PowerBI.

Power BI User's profile image Profile Picture

Power BI User on 06 Jul 2020 00:01:48

RE: Conditional Formatting for Text

Would be useful for displaying status info, e.g. like "Success" green, "Failure" red, "Partially succeeded" orange etc.

Power BI User's profile image Profile Picture

Dana Buck on 06 Jul 2020 00:01:37

RE: Conditional Formatting for Text

It surprises me that Microsoft would have thought that only NUMBERS would be relevant data to be used for reporting purposes in Power BI, and thus only NUMBERS would need to be subject to conditional formatting. For a company worth so much money, they lack SO MUCH in their ability to publish a complete and polished software product the first time around.

Merged Idea (2)