Forum Discussion
How to display average based on sliver values?
Hello,
I'm still a noob when it comes to Power Bi and at the moment i'm just playing around with it and I'm strugelling to work out how I would display an average depending on the duration chosen using a slicer.
For example I have a line graph showing the number of users that visited a website per day and I have a slicer which I can use to change the period of time which i can see that data for i.e. one week, one month etc. Next to those graphs I have card inserted currently showing the total number of users over the period selected.
I was wondering how I can how the average number of users over the chosen period rather than the total number?
Many thanks,
Kamil
Hi , CMMkamil
In card visual ,you only need to change the aggregation type of the field 'Users' from ‘sum’ to ‘Average’.
In line chart visual, you can create a measure as below:Measure = CALCULATE(AVERAGE('Table'[Users]),ALLSELECTED())Best Regards,
Community Support Team _ Eason
3 Replies
Average by what? By days, by hours? Do you care about duplicates?
CMMkamil Exactly what lbendlin said. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Hi , CMMkamil
In card visual ,you only need to change the aggregation type of the field 'Users' from ‘sum’ to ‘Average’.
In line chart visual, you can create a measure as below:Measure = CALCULATE(AVERAGE('Table'[Users]),ALLSELECTED())Best Regards,
Community Support Team _ Eason
