Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
40 | |
27 | |
20 | |
14 | |
8 |
User | Count |
---|---|
76 | |
48 | |
46 | |
20 | |
16 |