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
Hi samdthompson
If you do want the Average value to be a line, you could create this using a Calculated Table in the Power BI model. Which you could then use as part of your line?
In terms of the colors I am not 100% sure if you can do what you want, but you might be able to using a visual as long as the values remain constant, or you shape your data to ensure that the value names stay the same.
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