QT#83 - Conditional Formatting Power BI Table or Matrix Cells Using The Cells Text Content

  Рет қаралды 4,554

Jason Davidson

Jason Davidson

Жыл бұрын

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!
effectivedashboards.com/power...
👉 Power BI Quick Start PLUS - Learn how to craft KPI management dashboards that help you, your boss, and your peers make better decisions!
effectivedashboards.com/power...
-------------------------
📁 Resources
-------------------------
👉Access to the source PBIX files for this KZbin video:
effectivedashboards.com/cours...
👉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).
effectivedashboards.com/data-...

Пікірлер: 4
@159753rm1
@159753rm1 Жыл бұрын
Hello, is there a way to conditionally format just a delimiter rather than highlight the whole cell in a table? I have a long list of text values separated by semi-colon, and want to make it easier to read those values. Thanks
@user-vh6zb3vz3y
@user-vh6zb3vz3y 7 ай бұрын
Is this feature still available with Nov 2023 version? I cannot find it
@weeyoda
@weeyoda 5 ай бұрын
I am using Dec 23 version and also unable to see the option....has it been removed?
@Ayman154
@Ayman154 Жыл бұрын
Kindly can you do it for date
How to use Calendars
1:44
AI-Clinics
Рет қаралды 4
Sigma Kid Hair #funny #sigma #comedy
00:33
CRAZY GREAPA
Рет қаралды 38 МЛН
ПРОВЕРИЛ АРБУЗЫ #shorts
00:34
Паша Осадчий
Рет қаралды 7 МЛН
Why Power BI totals might seem wrong
27:55
SQLBI
Рет қаралды 51 М.
Build an Interactive Risk Matrix in Power BI (Button Slicer Technique)
35:37
How to Create Outstanding Power BI Reports (A Must Watch!)
14:11
Variance Arrow in a Column/Bar Chart | Power BI Tutorials
6:12
Driven BI Data
Рет қаралды 1,8 М.
Power BI Conditional Text Formatting Made Easy
10:22
superdatabrothers
Рет қаралды 69 М.
ADVANCED Matrix Formatting I ALTERNATE Column or Row COLOR in Power BI
16:36
Sigma Kid Hair #funny #sigma #comedy
00:33
CRAZY GREAPA
Рет қаралды 38 МЛН