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

    Paul on 05 Jul 2020 23:17:50

    RE: Conditional Formatting for Text

    I am surprised conditional formatting only seems to apply to numbers; it needs to be applicable to text.

    Also, whilst it does apply for numbers it doesn't seem to be extendable to total rows which is highly inconvenient too.

    Power BI User's profile image Profile Picture

    Shital on 05 Jul 2020 23:17:47

    RE: Conditional Formatting for Text

    This is pretty basic functionality. How are we supposed to drill through the big reports without proper visuals?

    Power BI User's profile image Profile Picture

    Mats on 05 Jul 2020 23:17:46

    RE: Conditional Formatting for Text

    A basic function in reporting to be able to change color if value >,

    Power BI User's profile image Profile Picture

    Chris on 05 Jul 2020 23:17:35

    RE: Conditional Formatting for Text

    I really need this so I can display red, amber, green status for project reporting

    Power BI User's profile image Profile Picture

    Amit Ganguli on 05 Jul 2020 23:17:22

    RE: Conditional Formatting for Text

    Please have this added ASAP.

    Power BI User's profile image Profile Picture

    Vincent Pray on 05 Jul 2020 23:16:33

    RE: Conditional Formatting for Text

    Have wanted this for so long! PBI dev - check out Dev Express for conditional formatting ideas - best functionality for this I've ever seen.

    Power BI User's profile image Profile Picture

    Sara Mesquita on 05 Jul 2020 23:16:33

    RE: Conditional Formatting for Text

    Really important! It is a basic need ...

    Power BI User's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:16:27

    RE: Conditional Formatting for Text

    This seems pretty basic. Should have been done by now.

    Power BI User's profile image Profile Picture

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

    RE: Conditional Formatting for Text

    I totally Agree with this; It would be great to conditional format a table and/or a matrix based on the cell text, not only numbers.

    Also, it would be nice to be able to have a full row to be conditional formatted based on a value from a specific column too!

    Power BI User's profile image Profile Picture

    andrew on 05 Jul 2020 23:15:43

    RE: Conditional Formatting for Text

    lack of this functionality make the use of Power BI completely useless as a project and program BI tool, we were considering its use however is back to excel and the current PPM tool

    Merged Idea (2)