Create an Average point on the x axis

[SteveIOW]

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

[Datavizuserpbi]

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

[Pragati11]

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

[SteveIOW]

Thanks @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.

[SteveIOW]

Cheers, but won't this just give me as below and displayed on the Y axis?

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

[Pragati11]

HI @SteveIOW ,

My suggestion is completly based on my assumptions as I don't know how your data structure is. Please share some screenshots and sample data to get your question answered.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[SteveIOW]

sorry - here goes...

The red av wait line is what I want. vertical Y axis shows how many people are waiting and horizontal x axis shows how long they have been waiting.

Data is structured in a table with number of waiters and length of wait. as per

WeeksWait , PeopleCount

     1                   10

     2                    5

     3                    6

     4                    3