Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 R...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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?