topic Conditional formatting based on changing values in Custom Visuals Development Discussion

Conditional formatting based on changing values

Anonymous — Tue, 13 Feb 2024 10:15:03 GMT

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.

Colour	Q1	Q2
Pink	9	9
Yellow	8	14
Blue	27	51
Green	8	2
Red	5	0
Orange	0	3

Please can anyone help?

Many thanks,

Lozza

Re: Conditional formatting based on changing values

lbendlin — Wed, 14 Feb 2024 00:53:46 GMT

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

Re: Conditional formatting based on changing values

Anonymous — Wed, 14 Feb 2024 07:56:45 GMT

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.

Re: Conditional formatting based on changing values

lbendlin — Wed, 14 Feb 2024 15:55:30 GMT

This is one option - feel free to modify