Forum Discussion
Creating Dynamic Normal distribution Bell Curve in Power BI
Hi All, I want a normal distribution curve for products launch price variance Year on Year for multiple locations. However I want the distribution curves to be dynamic depending on filters select...
| Year | Location | Product | Price | Year on Year Actual | Year on Year % variance |
| 2018 | Leeds | A | 100 | ||
| 2018 | London | B | 300 | ||
| 2019 | Leeds | B | 200 | ||
| 2019 | Leeds | A | 120 | 20 | 20% |
| 2019 | London | B | 210 | 60 | 30% |
| 2020 | Leeds | B | 180 | 20 | 10% |
| 2020 | Leeds | A | 90 | 30 | 25% |
| 2020 | London | B | 231 | 21 | 10% |
The above dataset is an example of what I would be using. I want each data point on the curve to represent the normal distribution of the Year on Year % variance for each product in a specific location. With each curve representing a different location. Obviously the dataset I will be dealing with will have far greater number of products to plot on the curve however I was wondering whether it is possible to present this all using measures?
Can I use Year on Year % variance as a measure within the Norm.Dist function to plot the data points for multiple products in a Power BI visual?
Any help is greatly appreciated!