How to combine only particular column

[Uma_Dhandpani]

Hi,

I have attached the sample data. I required the percentage of report as together comparing with the year-wise report

Having data as thisRequired as this

[v-eachen-msft]

Hi @Uma_Dhandpani ,

You can add a new calculated column to calculate the diffenrences of percentage and use this new column in the visual. 

Your sample data is like a matrix that is complex for PowerBI to handle. I think a table is better if you can get it.