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 you wont be able to create this chart exactly. You could add lines for bounds using either:
1. a static constant (under the analysis tab for a visual) if you were using a line or column chart
2. if the bounds change by some dimensionality in the model then make a related table (related by the relevant dimension) that holds say Dimesion in the rows and then a column called upper bound and one called lower bound these would have the relevant limits in them. You can make one through Ribbon/Home/Enter Data.
I would keep in mind what the data is trying to do. Obviously you are migrating a report from excel. Ask the question, can I do it in a better way using this new tool?
// 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