Using Color Names in Power BI Conditional Formatting (DAX)

Conditional formatting in Power BI plays a crucial role in making reports more intuitive, visually appealing, and easy to interpret. Most Power BI users are familiar with using hex color codes in conditional formatting, but many are not aware that color names supported by web browsers can also be used directly in DAX expressions . This feature makes your DAX formulas more readable, easier to maintain, and faster to develop—especially when working on complex reports.

Power BI follows web (HTML/CSS) color standards, which means any color name supported by all modern browsers can be used in conditional formatting rules. Instead of memorizing or repeatedly searching for hex values, you can simply return meaningful color names like "AliceBlue" or "Aqua" directly from a DAX measure.

Why Use Color Names Instead of Hex Codes?

Using color names in conditional formatting has several practical advantages:

• Improved readability of DAX measures

• Easier maintenance when updating or modifying rules

• Better collaboration, as color intent is clear to other developers

• Faster development, without constantly referencing hex codes

For example, "Red" is instantly understandable compared to #FF0000 .

Example: Conditional Formatting Using Color Names

Below is a simple DAX example that returns color names based on a value:

This measure can be used in
Conditional Formatting → Format by: Field value → What field should we base this on? : Select [Sales Color] Measure

Advanced Example: Multiple Conditions with SWITCH

This approach is cleaner, more scalable, and easier to extend when you have multiple thresholds.