Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Conditional formatting based on changing values

Hello,

I've been asked to show a graphic in a report that has up and down arrows to show the change from quarter to quarter.  I'm fairly new to PBI and have looked at lots of the replies online etc. but I can't get the to work as I think they should.

If I was working in Excel, I would use an IF Function, if this is > than that, Red.

The data I am working with is a specific count of something, there is no working out a percentage of a target number, it is either more than, or less than, the number in the previous month, an example below.

 

ColourQ1Q2
Pink99
Yellow814
Blue2751
Green82
Red50
Orange03

 

Please can anyone help?

Many thanks,

Lozza

 

 

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    what would the expected outcome look like based on your sample data?

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago
      ColourQ1Q2 
      Pink99=
      Yellow814up arrow
      Blue2751up arrow
      Green82down arrow
      Red50down arrow
      Orange03up arrow

       

      Either up and down arrows and an equals sign, or a colour coded symbol (red for down, yellow for equals, green for up)?

       

      Thank you for looking at this for me.