Average price in different years

[Shackwell]

Hello guys 

I already made a matrix for the following. which shows the sales report for 2015.

                  UNIT 01  UNIT 02    UNIT 03    UNIT 04

ZONE 01.       1            1           1.1            1.1

ZONE 02.       1.2.        1.3.        1.4.         1.5 

ZONE 03.      1.4.        1.2.          1.1.        1.3

average.         1.2.         1.2           1.2.        1.3

And I want to build the next graph. I want to use the AVERAGE and I want to see them across the years. But I believe i need to first create a measure to get the average price of the unit per year, and do that for every year and for every unit?

                   UNIT 1.     UNIT 2.   UNIT 3.  UNIT 4

YEAR 01.      1.2.           1.2           1.2         1.3

YEAR 02

YEAR 03

YEAR 04

Thank you once again for your time

[Shackwell · Accepted solution]

Thank you for the input. You know I did a measure myself to divide all sales $ for the amount of products sold. And somehow it seems to be working on my matrix.

[Data-estDog]

What does your data model look like? If you have a Date Dimension, you should be able to just drag the year column into the matrix and keep everything else the same for Average Price. If you don't have a date dimension, build one. There are many tutorials on youtube.
Example Before: 

Example after:

If you found this helpful, don't forget to mark as solution and give a thumbs up!