Forum Discussion
Column Chart with colored target range
Not specifically. But there are a couple workarounds...
This is the worst one because of the scale of the axis changes it could end up wrong. But you could theoretically insert a box with the color over the chart. Not recommended, but an option.
The simplest one is to create measures for the upper and lower boundaries of the range and add them in as lines.
if you want to get crazy, you could try an area chart or a stacked column chart But this would involve having to create measures that build the actual value off the lowest boundary. But you could set the area below the lowest boundary as completely transparent. Could get very tricky to work successfully.
Hope this helps!
- littlemojopuppy6 years agoCommunity Champion
Here's an example from something I did...not exactly what you asked for but it gets the point across.