How to create a trend graph which sum weeks as we go

[wdurand]

I am new in Power BI and trying to move over some charts i already had in Tableau but here is one type that is giving me problems.  How should i create a measure to have weeks amounts added as we go. Also, my X axis show week in numbers and can not sort them ascending, so shows first 1, 10, 11, 12, 2, etc, and can not make it go ascending.   Data is as simple as attached

Also not sure how to add those kind of comments like the one showed in the rectangle.

Any help will be appreciated

 

[v-shex-msft]

Hi @wdurand,

First, current power bi not support to use legend field and multiple value fields at same time.

Second, power bi trend line feature not supported customize, it only support to analysis existed current value.

So if you want to display trend line of weekly summarize, you need to drag this to value fields.

Regards,

Xiaoxin Sheng