Forum Discussion
AKSatPBI
2 years agoNew Member
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.