Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How to Create arrows showing increase and decrease of value

Hello people,   I wanted to ask for help with a thing I am stuck on.  Using arrows, I need to show in the last column if the value has either increased or decreased. When tried conditional formatti...
Show and Tell
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi Anonymous ,

     

    Based on your description, I have created a simple sample:

    Please try:

    Measure2 = IF(SELECTEDVALUE('Table'[Prior Value])<SELECTEDVALUE('Table'[Current Value]),1,-1)

    Then apply it to the visual -> conditional formatting:

    Best Regards,

    Jianbo Li

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

v-jianboli-msft's avatar
v-jianboli-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi Anonymous ,

 

What does your raw data look like? You can use the if function or switch function for these two columns of data to return the comparison result as a value like 1, -1, and then do conditional formatting.

For example:

Measure2 = IF(SELECTEDVALUE('Table'[Prior Value])<SELECTEDVALUE('Table'[Current Value]),1,-1)

 

Best Regards,

Jianbo Li

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