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, I have a calculated column of 'lead times' calcualted from the submission date and completed date. I also have a column of 'departments' When I build a pie chart or any other visual, it sums the departments lead times whereas I want to show an average leadtime for each department. Is there any way to do this? Thanks in advance
Which data type has the column Lead Time?
Try with this measure and put it in the Values field
Thanks for the response. The values 'lead time' is calculated as follows:
Please send sample data of your table Sheet1 and your expected result.
Thanks for the reply, this is what I was expecting to see and have done that in the past but I have no option there. Here is what I see.
Hi @Monty03 ,
try to select from here the avaerage, instead of the sum
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
100 | |
98 | |
86 | |
70 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |