Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Hello,
try this and create a measure = MEDIAN('Table'[Weeks])
it's what you want ?
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
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
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
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.
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |