Forum Discussion
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....
what would the expected outcome look like based on your sample data?
| Colour | Q1 | Q2 | |
| Pink | 9 | 9 | = |
| Yellow | 8 | 14 | up arrow |
| Blue | 27 | 51 | up arrow |
| Green | 8 | 2 | down arrow |
| Red | 5 | 0 | down arrow |
| Orange | 0 | 3 | up 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.
This is one option - feel free to modify