Average between time period 2021+2022 Bar chart

[ybyb23]

Hi all, 

I have a matrix table that shows the average in 2020 and average in 2021 and the total of both columns as average of both. Example in the table.

I tried to creat a Bar chart of this total by not filtering on the years and adding the measure  with average function , It seems not showing me the right values. in the data I just have these both years! 

How can I vizualize the total on a bar chart? how to automate based on the previous and current year avg?

Loking forward for your answers.

Herebelow is a sample, thank you

Ex : 

Segment	Year 2020	Year 2021	Total
Potatoes	20	12	16
Tomatoes	10	10	10
ognions	29	24	27
eggplant	28	16	25
cauliflower	34	31	33
Total	29	26	28

[amitchandak · Accepted solution]

@ybyb23 , refer to my blog/video on the same topic if that can help?

https://medium.com/@amitchandak/power-bi-add-grand-total-row-in-the-bar-visual-44c3d1d463be