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)
RE: Conditional Formatting for Text
Lets get this done. Easy fix Excel already has rules like this.
#LFG
RE: Conditional Formatting for Text
Yes please - conditional formatting on text values would appear to be basic funtionality
RE: Conditional Formatting for Text
It's in Excel, why isn't it in here? Seems pretty basic if you ask me...
RE: Conditional Formatting for Text
We have a financial report layout table where we setup the complete custom structure with headers, line spacing etc. Then use DAX to map to the reporting items (e.g. Revenue, COGS etc.). In Excel Pivot Tables I can easily manually set the e.g. "Total Revenue" line to be bold and larger font size. I imagine this feature would enable similar reporting in PowerBI.
RE: Conditional Formatting for Text
Would be useful for displaying status info, e.g. like "Success" green, "Failure" red, "Partially succeeded" orange etc.
RE: Conditional Formatting for Text
It surprises me that Microsoft would have thought that only NUMBERS would be relevant data to be used for reporting purposes in Power BI, and thus only NUMBERS would need to be subject to conditional formatting. For a company worth so much money, they lack SO MUCH in their ability to publish a complete and polished software product the first time around.
RE: Conditional Formatting for Text
Also need this.
RE: Conditional Formatting for Text
I know this isn't exactly what everyone is looking for, but conditional formatting by field may be a useful workaround - I've used it to format text fields in a table:
https://xxlbi.com/blog/conditional-formatting-by-field-value-in-power-bi/
RE: Conditional Formatting for Text
It is quite required that PBI allows us to conditionally format fields based on their text values. That feature has been around for ~20 year now on Excel... Why not in PBI???
RE: Conditional Formatting for Text
Just look at Qlik!! So simple.