Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Dual KPI

Hi,

 

TypeSale CountPrevious Month Sale CountSatisfied
Premium1516FALSE
Budget2120TRUE
Moderate108TRUE


I have some sample data below : 

 

I want to compare Sale count with Previous month sale count for each type of my product

Based on comparision I have a column called Satisfied i.e if current sales > previous sales, value is true else false.

 

I want to show the True or false value on a KPI like a traiangle 

Eg for True I want to show an upward poitning triangle in green

For false I want to show downward poiting triangle in red.

 

I have checked out custom visuals but none are precise. Is there a workaround?

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    Hi Anonymous,

     

    You can refer to this article  to use Unicode arrows in a measure and set conditional colors for it. Besides, this link lists some useful unicode character symbols.

     

    Best regards,

    Yuliana Gu