-
Book Overview & Buying
-
Table Of Contents
DAX for Humans
By :
Conditional formatting can greatly enhance the user experience when viewing reports, especially for quickly ascertaining the state of key performance indicators. While Power BI Desktop includes a robust rules editor for defining conditional formatting, many argue that any rules-based conditional formatting should rather be done in DAX measures.
If you have not already completed the Extracting Text section of this chapter, do so now.
To demonstrate using measures for conditional formatting, do the following:
Create the following measure:
CF 1 = MAX( 'Extraction'[Color] )
Place the Name, Color, and Number columns from the Extraction table into a Table visualization.
With the Table visual selected, in the Columns field well of the Visualizations pane, right-click the Name column.
Choose Conditional formatting.
Choose Font color.

Figure 4.2: Conditional formatting.
In the conditional formatting dialog, choose Field value for Format style.
Select the...