How to make normal distributions which can apply slicers

[acraig]

Hello,

I have a dataset with parameters such as..

-Project Type

-Material

-Test Method

and the only output i care about is "Test Result", which is numerical.

I am trying to create normal distributions in Power BI and have been following a youtube video from 2018 entitled "Normal Distribution (Gauss Curve) in Power BI (Part I)"  

So far what I have done is.. 

-Created new measure "Mean" which outputs the mean of the test result.

-Created new measure "Standard Dev." which outputs the standard deviation of the test result.

-Created new measures "X-3σ" and "X+3σ" for range of confidence.

Using these new measures, i added a slicer for each of the following:

-Project Type

-Material Name

-Test Method

Using the slicers, i can easily view any combination of project type/material name/test method and see the numerical output. 

I wish to also be able to visualize this data in normal distribution, with the slicers i select applying to the plot.  Does anyone have an idea how i might do this?  Following the youtube video-i first run into trouble when creating a new table, as the test result values displayed in the new table to not match actual test results.  The formula he used to create normal distribution table is 

NORMAL DISTRIBUTION =

VAR MinValue=floor([X-3σ],3)

VAR MaxValue=CEILING([X+3σ],3)

RETURN

SELECTCOLUMNS(CALENDAR(MinValue,MaxValue),"X",INT([Date]))

Any help is appreciated!!

Thank you.

[Greg_Deckler · Accepted solution]

@acraig - Just to follow up on this, see Page 11 of the attached PBIX file (below sig), something I was working on in another thread.

[Greg_Deckler]

@acraig Not sure I completely follow but NORM.DIST?

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