topic Creating Dynamic Normal distribution Bell Curve in Power BI in DAX Commands and Tips

Creating Dynamic Normal distribution Bell Curve in Power BI

RJ95 — Tue, 10 Dec 2019 15:18:18 GMT

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 selected (Locations, Product Types etc.). Is there a way to achieve this using DAX measures that allows for dynamic Mean/Standard Deviation/Normal distribution of Year on year price variances?

Visually I am looking for something similar to below with dynamic curve based on filters a set with with each colour being a different location and the data points being Year on Year price variances of each product:

Any help would be greatly appreciated.

Many Thanks,

RJ95

Re: Creating Dynamic Normal distribution Bell Curve in Power BI

Greg_Deckler — Tue, 10 Dec 2019 16:51:01 GMT

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

That being said, check out the NORM.DIST function. All of the parameters can be dynamic measures.

https://docs.microsoft.com/en-us/dax/norm-dist-dax

Re: Creating Dynamic Normal distribution Bell Curve in Power BI

RJ95 — Tue, 10 Dec 2019 20:41:59 GMT

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!

Re: Creating Dynamic Normal distribution Bell Curve in Power BI

MRuiz-FDC — Wed, 05 May 2021 16:22:16 GMT

Is there a solution for this?

I am looking for this also.

Re: Creating Dynamic Normal distribution Bell Curve in Power BI

Socksguy — Thu, 29 Dec 2022 21:18:51 GMT

Has there been any update since this post in 2019? I am looking to add a dynamic normal distribution bell curve to my report page.
I am attempting to visualize employee performance across 4 departments under one facility.

I have measures created for dynamic standard deviation and mean. These valuse of the measures will change with my slicers when I filter from Facility to individual departments to supervisors to associates.

I can create a calculated column for normal distribution pdf values. However, when applying a slicer the column does not recalculate the pdf normal value with the new sample size and therefore, will not alter the bell curve.

As far as I know, a measure in BI will not accept a column as an X value because it is looking for a sigular value for each calculation. So... using a measure for the normal pdf values is out..

Is there a way to create a "dynamic calculated column" that when I filter to a department, It will recalculate the normal pdf vaules based on the new sample size using only that departments performance outputs?

Re: Creating Dynamic Normal distribution Bell Curve in Power BI

Socksguy — Thu, 29 Dec 2022 21:31:15 GMT

Greg_Deckler

Re: Creating Dynamic Normal distribution Bell Curve in Power BI

Robert14358 — Fri, 15 Mar 2024 05:45:28 GMT

i am having the same issue and havent seen anyone help yet