Skip to main content

    Power BI

    Planned

    Conditional Formatting for Text

    Vote (2910) Share
    's profile image

    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)
    's profile image Profile Picture

    ee8443d8 b29b-461e-96d8-08dd4a615ce1 on 05 Jul 2020 23:17:22

    RE: Conditional Formatting for Text

    Please have this added ASAP.

    's profile image Profile Picture

    2c6411d6 4f95-4e03-be5c-bd22fa759f2d 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.

    's profile image Profile Picture

    7dc85c98 ad48-4f93-b3f5-b5fa71e1362d on 05 Jul 2020 23:16:33

    RE: Conditional Formatting for Text

    Really important! It is a basic need ...

    's profile image Profile Picture

    0d3f1844 200b-4d37-aa7f-c4acdf96fdc7 on 05 Jul 2020 23:16:27

    RE: Conditional Formatting for Text

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

    's profile image Profile Picture

    8b93c8c2 727a-4615-94e4-04237e926a92 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!

    's profile image Profile Picture

    ac1ad134 4814-467c-b0e7-0441c92add49 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

    's profile image Profile Picture

    e2e54545 d836-4951-b8ab-f66edad033c6 on 05 Jul 2020 23:15:43

    RE: Conditional Formatting for Text

    Agreed

    's profile image Profile Picture

    c4257270 3696-4dcc-98da-f15ce3acc642 on 05 Jul 2020 23:14:28

    RE: Conditional Formatting for Text

    and not only from cells text, we need the posibility to select a value from query or table

    's profile image Profile Picture

    01aa3760 b84a-4607-a978-8d43566ad3b3 on 05 Jul 2020 23:14:08

    RE: Conditional Formatting for Text

    Agreed. This seems well overdue for this product.

    's profile image Profile Picture

    dcf7aba7 9a85-4345-af9f-ab875916c9cc on 05 Jul 2020 23:11:10

    RE: Conditional Formatting for Text

    Unbelievable this is not yet possible. We try to switch our users to PowerBI from our legacy reporting tool but with lot of functionality we have to tell them... its not (yet) possible. It feels like going backwards.