Monthly/Yearly Percentage Changes in a Pivot Table

[Philhooh]

Dear all,

I am a newby with Power Bi and I am not familiar with all the possibilities offered by the product.

I have a time serie that I want to display a resumé with the monthly percentage changes and the yearly like this :

Can any one help ?

Thanks

[v-piga-msft]

Hi @Philhooh,

Matrix in Power BI may help you. You also could create calculated colum to get the monthly percentage in Power BI.

If you need addtional help, please share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

For reference, you could have view of this thread.

Best Regards,

Cherry

[Philhooh]

Hi,

Thank you very much for your help.

I have tried with a matrix but could not get the result. I am looking to have monthly performance for each year and a yearly performance on the last column to sum up the performance. 

I have attached my project but I don't know if it could help.

Best.

https://correlinvest-my.sharepoint.com/:u:/p/admin/ERfwgKSi2jtOp39_kltDTVQBbLj5yb-qOmjbjfL_iG4asw?e=...