Forum Discussion
reference band?
GilbertQ, I dont think an average value was asked for. I was suggesting something like this:
If you want the average then it would be easier to make a measure using something like:
Average = calculate(AVERAGE(Table1[Value]),all(Table1[Month]))
and create:
// If this is a solution please mark as such
hello everyone.
I have been trying to create a graph using the "line and Clustered column Chart" to achieve somewhat similar graph as above.
i currently managed until here:
I have 3 columns with value for color coding for Green, Red and yellow
Green is 75 and below. Red is 110 and above. Yellow is in between this two values. How do include the colored area to my graph that i drew? or probably a reference band? i am 1 day old to power bi so any help is greatly appreciated.
thank you!
Anonymous I believe you cannot achieve the color band in column chart. Same you can try out in stacked area chart. Hope this helps !