Creating Bell Curve using DAX

[polaris3028]

Hi All,

Need your help as I'm new to PBI.  I'm creating a scorecard that requires a bell curve metric.

Say:

Developer	Tasks Count
Dev 1	58.25
Dev 2	21.00
Dev 3	12.00
Dev 4	8.00
Dev 5	6.00

Can someone direct me on how to create a column or measure to show the bell curve of the tasks count that contains Bins of (1,2,3,4,5) where 1 = 5% of the tasks count, 2 = 15% of the tasks count, 3 = 60% of the tasks count, 4 = 75% of the tasks count and 5 = 80% of the tasks count.  Thanks in advance!

[v-caliao-msft · Accepted solution]

@polaris3028,

Here is a blog which describes creating Bell Curve and Histogram with Power BI Desktop using DAX, please refer to the link below.
https://www.mssqltips.com/sqlservertip/4076/create-bell-curve-and-histogram-with-power-bi-desktop-us...

Regards,

Charlie Liao

[UlisesCiccola]

Hi,

In the graph that you show you can see a bar graph but not a curve. Does anyone know how to transform it into a Gauss bell curve?

Thanks!

[Anonymous]

I'm working on creating a bell curve myself - i found this video on youtube by josep romero - and by following along, I've been able to create the curve - I just can't get my data to show up on it - but watch his 3 videos, and you'll at least get a good basis.  The 1st of the 3 video's is call "Normal Distribution (Gauss Curve) in Power BI (Part 1)