Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Shackwell
Helper III
Helper III

Average price in different years

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

1 ACCEPTED SOLUTION
Shackwell
Helper III
Helper III

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.

View solution in original post

2 REPLIES 2
Shackwell
Helper III
Helper III

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
Resolver II
Resolver II

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: 

DataestDog_0-1698946322257.png

 

Example after:

DataestDog_1-1698946402350.png

 

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.