Bell Curve visualization

[Hgsilva]

Good morning,

I'm having difficulties building a bell curve visualization in Power BI. Want to see this field displayed in a curve to see stddev.

[Anonymous · Accepted solution]

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. 

[parry2k]

@Hgsilva have you checked this video