Bell Curve visualization

Hi Hgsilva ,

 

First of all thanks to parry2k  for the quick reply and solution.
Here are the exact steps to follow:

(1) This is my test data.

(2) We can create measures.

Mean = AVERAGE('Table'[Order to Complete TAT in Hours])

StdDev = STDEV.P('Table'[Order to Complete TAT in Hours])

(3) We can create a BellCurveData Table and create a column on this table.

BellCurveData = 
VAR MinValue = MIN('Table'[Order to Complete TAT in Hours])
VAR MaxValue = MAX('Table'[Order to Complete TAT in Hours])
VAR Increment = (MaxValue - MinValue) / 100
RETURN
GENERATESERIES(MinValue, MaxValue, Increment)

NormalDistribution = 
VAR MeanValue = [Mean]
VAR StdDevValue = [StdDev]
VAR X = BellCurveData[Value]
RETURN
(1 / (StdDevValue * SQRT(2 * PI()))) * EXP(-0.5 * ((X - MeanValue) / StdDevValue)^2)

(4) Create a line chart.

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.