Skip to main content
Microsoft Idea

    Power BI

    Planned

    Conditional Formatting for Text

    Vote (4651) 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 03 Aug 2022 05:06:29

    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 (152)
    Power BI User's profile image Profile Picture

    Mahindra Bisram on 24 Sep 2021 13:32:42

    RE: Conditional Formatting for Text

    This is a basic feature/requirement that should be implemented asap.

    Power BI User's profile image Profile Picture

    Mohammed SUHEL on 03 Aug 2021 03:23:55

    RE: Conditional Formatting for Text

    It's been year when would this be implemented we need this and more Conditional Formatting options in Power BI. Thanks

    Power BI User's profile image Profile Picture

    Robert Ekroll on 08 Apr 2021 12:57:25

    RE: Conditional Formatting for Text

    Still after so many years conditional formatting/icon formatting based on text in the current cell is not available. Hope you can add this functionality soon

    Power BI User's profile image Profile Picture

    on 10 Nov 2020 00:26:51

    RE: Conditional Formatting for Text

    For example in card visualization. If my status is Red, I would like to change background color to red as well to stand out

    Power BI User's profile image Profile Picture

    on 10 Nov 2020 00:26:00

    RE: Conditional Formatting for Text

    For example in a table you can apply conditional formatting based on numbers, percentage or sales, but what about if you want to color formatting based on text taht woukd help a lot for non numeric users!

    Thanks in advance!

    Power BI User's profile image Profile Picture

    Kah Heng Yeong on 09 Nov 2020 06:41:19

    RE: Conditional Formatting for Text

    Actually it is possible to conditional format text in Power BI although it is not so straightforward.

    https://exceleratorbi.com.au/conditional-formatting-with-a-text-field-in-power-bi/

    But yes, if there is a direct function would certainly save heaps of time trying to manually write a DAX for it.

    Power BI User's profile image Profile Picture

    Atif Siddiqui 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

    Power BI User's profile image Profile Picture

    Mihail Delineshev on 25 Aug 2020 18:33:39

    RE: Conditional Formatting for Text

    Hi PBI Team,

    this feature is very important to be added! It would greatly impove the visualisation of data in a report.

    Power BI User's profile image Profile Picture

    Power BI User on 06 Jul 2020 00:17:30

    RE: Conditional Formatting for Text

    The text based comparisons would be really useful. Hopefully they will be added soon.

    Power BI User's profile image Profile Picture

    Power BI User on 06 Jul 2020 00:17:09

    RE: Conditional Formatting for Text

    I can't believe it isn't still in Power BI.

    Merged Idea (2)