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.
I'm trying to build a Standard Deviation based on these rules:
I know I can't create a bell chart like that in PowerBI, but I'm trying to at least create the categories for the intervals/sigma values.
i.e:
=switch(true(),
StandardDeviationInterval>=68.2%,"SD1",
StandardDeviationInterval<68.2% && StandardDeviationInterval>=27.2%,"SD2",
StandardDeviationInterval<27.2% && StandardDeviationInterval>=4.2%,"SD3",
StandardDeviationInterval<4.2% && StandardDeviationInterval>=0.2%,"SD4","SD5+")
How do I calculate this deviation interval?
I know how to calculate the standard deviation and the distribution with STDEV.S and NORM.DIST respectevely but these do not give me those 5 ranges/intervals I need.
You might try creating a disconnected table with a row for each range (SD1, SD2, etc.). Then use this table in the visual, and use DAX to get the amount for each range.
Here's a free histogram visual:
Proud to be a Super User!
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |