Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I want a normal distribution curve for products launch price variance Year on Year for multiple locations. However I want the distribution curves to be dynamic depending on filters selected (Locations, Product Types etc.). Is there a way to achieve this using DAX measures that allows for dynamic Mean/Standard Deviation/Normal distribution of Year on year price variances?
Visually I am looking for something similar to below with dynamic curve based on filters a set with with each colour being a different location and the data points being Year on Year price variances of each product:
Any help would be greatly appreciated.
Many Thanks,
RJ95
i am having the same issue and havent seen anyone help yet
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?
Is there a solution for this?
I am looking for this also.
Year | Location | Product | Price | Year on Year Actual | Year on Year % variance |
2018 | Leeds | A | 100 | ||
2018 | London | B | 300 | ||
2019 | Leeds | B | 200 | ||
2019 | Leeds | A | 120 | 20 | 20% |
2019 | London | B | 210 | 60 | 30% |
2020 | Leeds | B | 180 | 20 | 10% |
2020 | Leeds | A | 90 | 30 | 25% |
2020 | London | B | 231 | 21 | 10% |
The above dataset is an example of what I would be using. I want each data point on the curve to represent the normal distribution of the Year on Year % variance for each product in a specific location. With each curve representing a different location. Obviously the dataset I will be dealing with will have far greater number of products to plot on the curve however I was wondering whether it is possible to present this all using measures?
Can I use Year on Year % variance as a measure within the Norm.Dist function to plot the data points for multiple products in a Power BI visual?
Any help is greatly appreciated!
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
That being said, check out the NORM.DIST function. All of the parameters can be dynamic measures.
https://docs.microsoft.com/en-us/dax/norm-dist-dax
User | Count |
---|---|
53 | |
28 | |
19 | |
18 | |
14 |
User | Count |
---|---|
92 | |
86 | |
39 | |
23 | |
22 |