Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

reference band?

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 ...
  • samdthompson's avatar
    samdthompson
    9 years ago

    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