Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 38 | |
| 36 | |
| 28 | |
| 28 |
| User | Count |
|---|---|
| 124 | |
| 88 | |
| 74 | |
| 66 | |
| 65 |