Forum Discussion

AKSatPBI's avatar
AKSatPBI
New Member
2 years ago
Solved

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

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 ! 

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

3 Replies

  • 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.

  • 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's avatar
      lbendlin
      Super User

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