Change shape or KPI border colour based on value

[C_Lee]

Hey Communnity

I have a bit of an issue that has me a tad stumped, I have a request to change the border of either a rectangle shape or KPI visualisation based on the value therefore creating a RAG status.

How would I do this in DAX, strugglijng to wrap my head around it.

Any help appreciated.

Cheers,

Chris

[amitchandak · Accepted solution]

@C_Lee , Border color support Fx, You can create a color measure and use that in advance conditional formatting using field value option

example

Color sales = if(AVERAGE(Sales[Sales Amount])<170,"green","red")

How to do conditional formatting by measure and apply it on pie? : https://youtu.be/RqBb5eBf_I4

[C_Lee]

Thank you I will give that a go, appreciate the prompt response

[C_Lee]

@amitchandak I have created the measure as you have mentioned and now for some odd reason I am unable to select it from the 'What field should we base this on?'.....it is grayed out. Do you know what would be causing that?