Forum Discussion

MichaelaMul's avatar
MichaelaMul
Helper III
1 year ago
Solved

Conditionally Format X-Axis

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!  
Need Help
  • OwenAuger's avatar
    OwenAuger
    1 year ago

    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

v-kpoloju-msft's avatar
v-kpoloju-msft
Community Support
1 year ago

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's avatar
v-kpoloju-msft
Community Support
1 year ago

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.