KPI For up and down of Actual Vs ICE

[Amardeep100115]

Hi

I wish to be have KPI up and down arrow for greater and less value for ICE, Pre Month ICE, Actual and pre month Actual 

For Data click here 

Please advice

[v-yuta-msft]

@Amardeep100115 ,

You may use UNICHAR() function to generate the arrow. For more details, you can refer to video below:

https://www.youtube.com/watch?v=cboA5AtAPeg

Regards,

Jimmy Tao

[Amardeep100115]

I tried but what i am looking for is a card visual with up and down arrow in visualization.

i mean when i select a month the and visual get changed, accordingly the arrow visual needs to be change in card

[Amardeep100115]

can anyone help me on this

[v-yuta-msft]

@Amardeep100115 ,

Just convert calculate column to measure like below:

Measure = SWITCH(SELECTEDVALUE('Table'[Data]), 1, UNICHAR(9650), 2, UNICHAR(9651))

  

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Amardeep100115]

Could you please rework with my shared data

[v-yuta-msft]

@Amardeep100115 ,

I'm confused on your requirement. Could you show the expected result of the sample you provide?

Regards,

Jimmy Tao