Forum Discussion

RJ_KON's avatar
RJ_KON
Icon for Helper I rankHelper I
7 years ago
Solved

Measure to show up and down arrows in a table

    Hi guys, i am new to power BI and struggling to write measure to show up and down arrows based on my calculated coulmn values. Below is my table I am trying to create a measue KEY =IF([...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi RJ_KON ,

     

    Your measure should be:

    KEY =
IF (
    SELECTEDVALUE ( VARIANCE_19_20[Difference] ) > 0,
    UNICHAR ( 9650 ),
    UNICHAR ( 128315 )
)

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi RJ_KON ,

 

Your measure should be:

KEY =
IF (
    SELECTEDVALUE ( VARIANCE_19_20[Difference] ) > 0,
    UNICHAR ( 9650 ),
    UNICHAR ( 128315 )
)

Best regards,

Yuliana Gu

RJ_KON's avatar
RJ_KON
Icon for Helper I rankHelper I
7 years ago

Hi Yuliana Gu, that worked perfectly.

 

Thank you very much.

RJ_KON