Change the Banding type property to one of the following:
Increasing is better – Increasing is best when you’re measuring things like sales or profit. If you go over your profit target that’s a good thing!
Decreasing is better – Decreasing is probably best when you’re looking at something like budgeting. Staying under budget is usually a good thing. Unless you being too far under budget means you won’t get that money again next year which leads to the last option
Closer is better – This is for when you need your data to land in the middle of a bell curve. Meaning if you go too high or too low that’s a bad thing. This is often useful when looking at medical data. For example, if your blood pressure is too high then that’s a bad thing, but if you’re blood pressure is too low that’s also a bad thing too. You need to land in the middle somewhere, which is what this option allows.
There’s plenty of good advice here, so check out the video.