Forum Discussion
Distribution Chart
Good day Everyone,
I hope that you can enlighten me with what path should I take. As this is my first time creating a report similar to the chart below, I am unsure if I this is a Normal Distribution Chart (I have very small knowledge about this) or I am just making this complicated as I am unable to replicate this on PoweBI.
Thank you in advance!
Hey, @Nico_Branuelo
It's a pleasure to answer for you.
You can check the following link to create a distribution chart using thse functions.
https://docs.microsoft.com/en-us/dax/norm-dist-dax
https://docs.microsoft.com/en-us/dax/stdev-s-function-dax
https://docs.microsoft.com/en-us/dax/averagex-function-dax
Here is an example file. I hope it helps.
If you do not solve your problem, please feel free to ask me.
Best regards
Janey Guo
If this post helps,then consider Accepting it as the solution to help other members find it faster.
6 Replies
Anonymous , see if this can help
Hey, @Nico_Branuelo
It's a pleasure to answer for you.
You can check the following link to create a distribution chart using thse functions.
https://docs.microsoft.com/en-us/dax/norm-dist-dax
https://docs.microsoft.com/en-us/dax/stdev-s-function-dax
https://docs.microsoft.com/en-us/dax/averagex-function-dax
Here is an example file. I hope it helps.
If you do not solve your problem, please feel free to ask me.
Best regards
Janey Guo
If this post helps,then consider Accepting it as the solution to help other members find it faster.
Hello v-janeyg-msft ,
Thank you for this. I see that your file has a better and easier way of calculating the Normal Distribution.
The thing that confuses me is that when should I use the Normal Distribution :
- When there are only few data available like on the sample that I gave?
- Is it also applicable on around 2k data? (this is the one that I am working on)
Sorry if this is not clear, I am helping on a project which we are unable to tell if we should follow the normal distribution formula.
Edit : On your file with the formula of Normal Distribution, may I know why did you multiply it by 1000?
Many Thanks!Hi, Anonymous
I'm not clear what your data looks like.In my opinion,You need to have a set of data and calculate their average and variance to get a normal distribution graph,then you can predict the location and probability of the data.
The more data, the more accurate the result should be.As for the other, I don't know much and sorry I am just a PBI technical engineer.Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello v-janeyg-msft ,
I really appreciate your time on this. You have saved so much time for me. The last question that I have is, and I don't know if this is even a valid question, why did you multiply the normal distribution by 1000 on your table?
Thank you!Hi, Anonymous
It's irrelevant, I just want to make the value not so small.It can be deleted completely without any impact.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
