Calculate Percentage Change on a Trend Line

[JPScotland]

The graph below shows progress over the past 6 weeks.  I'd like to find out the percentrage increase/decrease on the trend line.

I'm thinking I may need to record some sort or weekly running total.  Diff between week 1 and week 2, then week 2 to week 3 and so on, then average it out?

Cheers,

JP

[amitchandak]

@JPScotland , use relative date slicer to display the last 6 weeks.

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

TO create a week of your choice -https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Powe...

Week on week data

https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...