Power BI

Planned

Conditional Formatting for Text

Vote (2910)

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 09 May 2018 06:00:57

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 (133)

Comments (133)

Neelima Putrevu on 07 Mar 2023 11:54:37

RE: Conditional Formatting for Text

66366d4c a6df-ea11-a813-000d3a8faea9 on 10 Sep 2020 07:45:03

RE: Conditional Formatting for Text

Desperately need ability to format cell as well as the entire row in the table visual based on text value. i have a table of features with columns Backlog ID, Title, Status, Size, Assigned to. I want to color the entire row based on status.

If status = "Done" the row background color becomes Green
If status = "In Progress" the row background color becomes Yellow
If status = "Dropped" the row background color becomes Orange