Skip to main content
Microsoft Idea

    Power BI

    Planned

    Conditional Formatting for Text

    Vote (4660) 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

    Jens JK on 06 Jul 2020 00:17:08

    RE: Conditional Formatting for Text

    don't forget columns with boolean data type, while implementing this!

    Power BI User's profile image Profile Picture

    Power BI User on 06 Jul 2020 00:16:14

    RE: Conditional Formatting for Text

    please add this.

    Power BI User's profile image Profile Picture

    Frédéric Brousse on 06 Jul 2020 00:15:47

    RE: Conditional Formatting for Text

    I would need this for my reports please

    Power BI User's profile image Profile Picture

    Alex Power BI User on 06 Jul 2020 00:15:27

    RE: Conditional Formatting for Text

    This would be helpful!

    Power BI User's profile image Profile Picture

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

    RE: Conditional Formatting for Text

    Please, I need this for a project I'm working on!

    Power BI User's profile image Profile Picture

    A B on 06 Jul 2020 00:14:37

    RE: Conditional Formatting for Text

    any update for this? Thanks

    Power BI User's profile image Profile Picture

    Power BI User on 06 Jul 2020 00:14:33

    RE: Conditional Formatting for Text

    Come on PBI, get this over the line! We need to be able to easily conditional format text like in Excel. IF the value is Yes, the colour text green etc.

    Power BI User's profile image Profile Picture

    Matthew Parowski on 06 Jul 2020 00:13:02

    RE: Conditional Formatting for Text

    Not quite two years since the official Microsoft response... any update?

    Power BI User's profile image Profile Picture

    Power BI User on 06 Jul 2020 00:12:24

    RE: Conditional Formatting for Text

    Have tables that have rankings with high medium and low would love to color code these in te the table

    Power BI User's profile image Profile Picture

    ABU on 06 Jul 2020 00:10:38

    RE: Conditional Formatting for Text

    This feature is very welcomed to highlight status informations like on track etc.
    conditional format on field content is very helpful.

    Please improve PowerBi by this function - since May 2018 its planned....

    Merged Idea (2)