X Axis Text Formatting to colour

Hi Creative_tree88 ,

To highlight "Liverpool" on the X-axis in your Power BI chart, you can achieve this by creating a custom DAX measure that conditionally formats the text color based on the value in the "Provider Name" field. Since Power BI does not support direct conditional formatting of X-axis labels, this workaround involves using a measure to dynamically change the color of the text based on whether the value equals "Liverpool."

Start by creating a DAX measure to return a different color code when the Provider Name is "Liverpool." You can use the following DAX code:

HighlightProvider = 
IF(
    SELECTEDVALUE('Provider Name'[Short text]) = "Liverpool",
    "#FF0000",  // Red color for Liverpool
    "#000000"   // Black color for all other values
)

Once you've created this measure, go to the Format pane of your visual, select "Data colors," and apply conditional formatting using the HighlightProvider measure. This will ensure that "Liverpool" stands out in a different color on the X-axis.

Alternatively, if you prefer to make "Liverpool" stand out by modifying the text label itself, you can create another measure to add symbols or text around "Liverpool" to differentiate it from other values. Here's an example of a custom label measure:

CustomLabel = 
IF(
    SELECTEDVALUE('Provider Name'[Short text]) = "Liverpool",
    "Liverpool (Highlighted)",  
    SELECTEDVALUE('Provider Name'[Short text])
)

Replace the original "Provider Name" field in your chart with this CustomLabel measure. This will add visual emphasis to "Liverpool" directly in the chart labels. While this doesn't change the color of the X-axis label text itself, it draws attention to the specific value you want to highlight.

Best regards,

DataNinja777 Many thanks.  Can you perhaps demo this for me, please?  I created the measure, but the X axis text is all still black.  Liverpool is not shown in red.  Many thanks.