Forum Discussion
Helper IICreate an Average point on the x axis
HI, fairly new to PBI so forgive my ignorance.
I a clustered bar chart showing a waitinglist distribution. e.g 10 people waiting 1 week, 5 waiting 2 weeks, 6 waiting 3 weeks and so on.
I want to display the mean wait ( and median actually) on the chart - i.e. have a line coming up from the x axis to show where the average wait is.
Is this possible? if so - how??
cheers
8 Replies
- Pragati11
Super User
Hi SteveIOW ,
Not exactly sure on your question, but you can get an Avergae line plotted by using the following option on a clustered bar chart viusl in Power BI:
If this doesn't help add more details to your question:
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
SteveIOWThanks Pragati11
I've used that function a few times. however in this example it will give me the average number of people waiting but what I actually need is the avergae wait time. i.e. the difference between (from the example above),
(10+5+2+6)/4 showing on the Y axis
and
(10*1 + 5*2 + 2*3 + 6*6)/23 showing on the X axis
- Pragati11
HI SteveIOW ,
In that case you can create two measures: (assuming you have number of waiting and Number of weeks as columns in your data:
Average Waiting = AVERAGE(yourTable[Number of Waiting] Average Weeks = AVERAGE(yourTable[Number of Weeks]Also I don't know what is the structure of your data, so see if above helps.
Then move these 2 measures to the Values section of your bar chart.
DatavizuserpbiHelper I
Hello,
try this and create a measure = MEDIAN('Table'[Weeks])
it's what you want ?- SteveIOW
ah, no I don't think so because my table is already cumulative. i.e.
WeeksWait , PeopleCount
1 10
2 5
3 6
4 3
I think what you suggest will only give me the average of either 1,2,3,4 or 10,5,6,3
