DYNAMIC Normal Distribution Plot (Bell shaped curve) using varying Mean (measure)

[AKSatPBI]

Hello,

I want to create a dynamic normal distribution plot which shifts on moving the slider. I was using below logic to do so in excel, where on shifting the slider > Mean value changes > X column values get update > thus, normal plot also shifts along x-axis.

In BI Desktop, though I am able to vary the Mean measure (using slider), but above table created using the mean measure does not get updated, thus Normal plot doesn't shifts.

Have already tried creating UNION(ROW(<above table>)), but it also yields STATIC TABLE.

Same is the case with NORM.DISTR(X, Mean, SD, 0) where X value doesn't get updated.

Any solution for this ? 

Thanks ! 

[AKSatPBI]

@lbendlin Thanks for the suggestion.

Thing is I have to use 10+ sliders to effect a single plot/mean. So it isn't feasible to tabulate so many permutations. say nPr = 11P10 = 39916800

[lbendlin · Accepted solution]

There is no need for slicers. Use the filter pane.

[lbendlin]

You can't just "move the mean" - you will need to provide a different set of data that justifies the shift of the mean.  

For example you could use the slider to add the same value to all your x axis data points.