unichar with color

[Anonymous]

Hi ,

I am trying to show the YoY percentage along with the UP and DOWN arrow buttons based on the value variance. For the buttons I have created a DAX function with UNICHAR .

Arrows  = SWITCH(TRUE(),[YoY%]<=0,UNICHAR(128315),[YOY%]>=.010,UNICHAR(9650),BLANK())

The arrow indicators are working fine based on the values, but I am not able to show the colors part . here I would like to show Green card if the Arrow goes up and same way Red color if arrow goes DOWN.

Is there any way to add the color code in DAX function . or what could be the best way to achieve it .

Anticipate your positive and quick response

[Anonymous]

You cant do it within the measure itself, but depending on the visual you are using you can use conditional formating to very easily change the colour

[Anonymous]

I am using a nornal gird . not any KPI cards 

[v-piga-msft · Accepted solution]

Hi  @Anonymous ,

By my research and test, there is no unicode for green arrow up directly, but we can use (9650) grey arrow and switch to green under column formating, select the measure Arrows changue font color to green.

Here is my test result.

More details, please refer to my attachment.

In addition, you also could have a reference of this similar thread.

Best  Regards,

Cherry