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)
- Merged Idea (2)
RE: Conditional Formatting for Text
Being able to do conditional formatting based on text would be a life saver!
RE: Conditional Formatting for Text
This would be a life saver.
RE: Conditional Formatting for Text
I would like to be able to conditionally format based on certain text values entered in as a formula like ="Davey Jones". This would be useful, thanks.
RE: Conditional Formatting for Text
I would like to be able to change the font type and also the cell borders for an entire row (or conceivably column) based on the value of a dimension that is being displayed in the table/matrix. This would allow me to create formatted financial reports more easily.
I create dynamically calculated totals / subtotals that are based on the dimension values (using DAX SWITCH logic) -- and I would like the ability to define unique total/subtotal look and feel for any given row(dimension). I want the same ability to define a look and feel for my dynamically defined total/subtotals as I can do with the pivoted view totals/subtotals.
RE: Conditional Formatting for Text
Hello,
When can we expect to be able to apply conditional formatting to text fields, based on the actual text, rather than a numeric value?
Text fields are not always linked to a numeric value.
It's a basic Excel feature and frustrating not to have it in Power BI
RE: Conditional Formatting for Text
Get errr done :)
RE: Conditional Formatting for Text
Hi Amanda, how is it going with the feature to conditionally format based on text input?
RE: Conditional Formatting for Text
Hello,
I would also like to know when this item will be updated.
RE: Conditional Formatting for Text
Hi, What is the status of this feature? When are you planning to release this? Thanks :)
RE: Conditional Formatting for Text
Would be great to be able to colour a text column based on the text it contains. E.g. Simple Yes/No column which you could colour "Yes" in green and "No" in red.
The conditional formatting options feel quite limiting in comparison to Excel's options. My clients are still blown away by all the amazing features they have available on their reports but baffled by the fact that I have to provide some of the reports in an Excel document because Power BI is not capable of displaying the information in the way they wish to see it.