Conditionally Format X-Axis

[MichaelaMul]

Hi,

I would like to change the color of the Rakuten to red on the X-Axis- is there a way to do this? I added the following rule but it doesn't seem to work. 

Thank you!

[v-kpoloju-msft]

Hi @MichaelaMul,

May i know has your issue been resolved? If the response provided by the @OwenAuger, and @Akash_Varuna, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

If yes, kindly accept the useful reply as a solution and give us Kudos. It would be appreciated.

Thank you for your understanding!

[v-kpoloju-msft]

Hi @MichaelaMul,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-kpoloju-msft]

Hi @MichaelaMul,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.

[OwenAuger · Accepted solution]

Hi @MichaelaMul 

Unfortunately the conditional formatting for the X-axis is computed once for the entire axis, not for each individual label on the X-axis. The axis labels must all be formatted the same colour.

If you examine the DAX query generated by the visual using Performance Analyzer, you will see a portion of the query similar to below that returns the minimum (i.e. "first") Brand in order to determine the axis text colour:

EVALUATE
    ROW(
        "MinBrand", CALCULATE ( MIN ( YourTable[Brand] ) )
    )

This is evaluated at the visual level, and the formatting condition would only be true when only the single Brand "Rakuten" is visible in the overall context of the visual.

There could be custom visuals out there that can do this, and I imagine it's possible to do this with Deneb if you want to explore that.

Regards

[Akash_Varuna]

Hi @MichaelaMul Could you try these please

1. Create a New Column for Conditional Formatting:

X_Axis_Color = 
IF(
    [X_Axis_Field] = "Rakuten", 
    "Red", 
    "DefaultColor" 
)

​

              This column will assign "Red" to "Rakuten" and a default color to all other values.

1. Apply Conditional Formatting:

• Go to the Formatting pane of your chart.
• Navigate to Data colors or X-axis formatting.
• Select Conditional Formatting and set it to use the newly created column.