Click 'Get data' -> 'Excel' -> Either 'Load' or 'Edit'.
To keep certain values for a column click the column and only select the value of interest. Then click 'close and apply'.
Click the 'Map'. Drag the country data to 'location'.
Click 'New Visual'. Drag 'year' to axis. Drag a column to 'Value'. Click the down arrow to select 'Sum' or 'Average'
In 'Insert' pane click 'Text box'
Just below the graph click the 'Painters Tool'.
For 'Custom Column Chart', Click 'X-axis' and make the type 'Categorical' and change the 'Inner padding' to 0%.
To show data on top of bar click 'Data labels' On.
https://docs.microsoft.com/en-us/power-bi/visuals/service-tips-and-tricks-for-color-formatting
Drag the data to 'Color Saturation'. Click on the paint brush, click on 'Data colors', Make 'Minimum' and 'Maximum' around 0 e.g. -30 and 30.
Click on 'Edit Queries' -> 'Data Source Settings'
Click on the 'painters tool' then click 'Y-axis' then click the 'Title On' button.
Click 'Edit Queries' -> 'Add Column' tab