It's been a while coming but finally, it's possible to add conditional formatting to a cell in a Power BI table or matrix based on the text content of the cell.

Prior to this Feb 2023 update, it was only possible to add conditional formatting, using the standard Power BI Desktop rule builder, to cells based on the cell's value if the value was a number.

It was and still is possible to use DAX measures to drive the formatting, but this was often not a suitable approach for those who are new to Power BI.

It is now possible to create a rule to add conditional formatting, for example, colour the background or the font, based on the text value in the cell. For example colour the cell background red if the value is "safety" or colour the font green if the value in the cell begins with a W etc.

-----------------------------------------------------
🎓 Power BI Dashboard Training
-----------------------------------------------------
👉FREE Power BI Quick Start Course - Learn how to create your first dashboard in around 90 minutes!
[ Ссылка ]

👉 Power BI Quick Start PLUS - Learn how to craft KPI management dashboards that help you, your boss, and your peers make better decisions!
[ Ссылка ]

-------------------------
📁 Resources
-------------------------
👉Access to the source PBIX files for this YouTube video:
[ Ссылка ]

👉Article series on creating a maintenance management system data model and how to address the human factors of data collection for improved data quality. (This is not just relevant to maintenance and reliability data).
[ Ссылка ]

свернуть