Show hardcoded values for particular year

[lbendlin]

Try looking at the issue differently.  In Power Query, in you main query add a filter to remove 2020 data.  Then append your 2020 fixed value data to the main query.

[Anonymous]

Hi @lbendlin, 

Thanks for your time and the response. I have got the solution and now i can able to show those values in my chart.

Best Regards,

Srihari