Year over Year comparison

[gusdahu]

Power BI Community,

I am attempting to create a bar chart that compares the year over year number of Purcahse Orders approved by month year. I also want my bar chart to include a line reflecting the percentage change over the period. I was able to create the comparison bar chart but not the line to show the percentage change. See screenshot above for additional information. Currently the line graph is taking the sum of the number of POs approved for each month/year and plotting it on the graph. I would like the line to show the percentage change of the number of POs created by month/year.

Any assitance will be appreciated.

Gus Dahu

[Anonymous]

@gusdahu hey, are you asking for the formula for % change?

try looking at this post I did.

https://community.powerbi.com/t5/Desktop/How-do-I-get-previous-value-from-last-month-into-a-new-colu...

once you have the result you can put it in the line chart as you have done in the above chart