You could add a new calculated field to your query, for example a field called comparison with values of:
-1to indicate it is less than the previous value0to indicate it is the same as the previous value1to indicate it is more than the previous value
Here’s an example of what the data coming back from your query might look like.
You can then use the Color by field property on your comparison field.
And then define value mappings for the colors:
This will result in a bar chart that looks like this:
