Forum Discussion
Creating Dynamic Normal distribution Bell Curve in Power BI
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?
- Socksguy3 years agoNew Member