Forum Discussion
Change shape or KPI border colour based on value
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
Anonymous , 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
3 Replies
- amitchandak
Super User
Anonymous , 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
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?