vizualisation of average price in column chart

[kamalkirfa]

Hi everybody,

i'm traying to create a graphical visualisation to show the evaluation of the price of a product during the last year.

what i want to have in the graphic is the average price of this product ( in the year). after that, to see the average price by month and after that to see the average price by day.

The problem is that power BI gives me the total amount instead of the average price. what do you advice me to do?

thanks in advance

[v-haibl-msft · Accepted solution]

@kamalkirfa

You can select “Average” for the Value field as below, and try to use the updated drill experience which has been introduced recently.

Best Regards,

Herbert

[kamalkirfa]

@v-haibl-msft thanks you very much dear. That's what i need.

@GilbertQ thank you too

[GilbertQ]

It would depend on how you are trying to visualise the data. If you want it to be side by side, you could then create 3 seperate measures?

Average Price by Year

Average Price by Month

Averagae Price by Day

Here is an example where they create an average for the month: https://community.powerbi.com/t5/Desktop/Calculate-an-average-from-a-Sum-by-Month/td-p/27250 

Another option is to create an Average calculated measure. And then create 3 different visuals, with each one at a different level on the axis. So one would use the axis of year, another one for month and then finally another one by day.

I would suggest putting in a date table to help with the process.