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 (153)
- Merged Idea (2)
RE: Conditional Formatting for Text
Please can you get this one delivered? Our users are used to having this functionality in other data visualisation tools, so not having it is exactly the sort of thing that makes colleagues challenge us moving to Power BI.
RE: Conditional Formatting for Text
Please add this feature as makes visualisation of issues a lot easier
RE: Conditional Formatting for Text
Please update. Tableau has had this functionality for years. I really saddens me that Power BI doesn't have this capability yet. Please prioritize.
RE: Conditional Formatting for Text
This is badly needed... I need to have a table cell turn green if true and red if false. It looks like you have everything in place already, not sure why simple text value match is not already in the software.
RE: Conditional Formatting for Text
Any updates on this?
RE: Conditional Formatting for Text
Planned since May, 2018?
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.