Forum Discussion
Creating Bell Curve using DAX
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!
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-using-dax/Regards,
Charlie Liao
3 Replies
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-using-dax/Regards,
Charlie Liao
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!
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)
