Line chart graph interpretation

[Death4Free]

Hi! How can I interpret graph in this way ?                                   

But not in this way, like it happen now (3 measures added to line chart)

               

Average 9, Average 6, Average 3 are measures.

[dplr-rn · Accepted solution]

Use value list

e.g. dimension

=ValueList('9 Month','6 Month','3 Month') 

expression

if (ValueList('9 Month','6 Month','3 Month')  = '9 Month',

          Avg( {<OrderDate={"<=$(=Max(OrderDate)) >=$(=AddMonths(Max(OrderDate),-9))"}>} LineSalesAmount),

          If( ValueList('9 Month','6 Month','3 Month')  = '6 Month',

                  Avg( {<OrderDate={"<=$(=Max(OrderDate)) >=$(=AddMonths(Max(OrderDate),-6))"}>} LineSalesAmount),

                  Avg( {<OrderDate={"<=$(=Max(OrderDate)) >=$(=AddMonths(Max(OrderDate),-3))"}>} LineSalesAmount)))

check link for some theory

ValueList() – For those tricky situations

[Death4Free]

Thank your for help!

[dplr-rn]

No problems