Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
98 | |
89 | |
73 | |
62 | |
61 |