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 formatting, I was able to do the arrows pointing in upward direction showing increase in value but I am unable to show the downward arrow for decrease of value. I also tried DAX programming, but seems it didn't work either. Can someone here please guide me. Attaching my screenshot below for your reference. 

 

 

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.

8 Replies

  • v-jianboli-msft's avatar
    v-jianboli-msft
    Community Support
    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi There,

       

       Thanks for the solution, but not all rows are showing the right trends. 

      Below is the conditional formatting condition used by me: 

       

      I would appreciate it if you help me out with the right condition, been stuck here for past 3 days. 

      • lbendlin's avatar
        lbendlin
        Super User
        3 years ago

        in order for your measure to work correctly you need clean data.  Neither "NA"  nor "BBB+"  are numbers.

  • v-jianboli-msft's avatar
    v-jianboli-msft
    Community 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.