How To create Distribution Chart(Bell chart) in Power BI

Hi Anonymous 

For the color legend, you could split the line into 3 lines. Create measures for 3 Risk score separately and put all of them into Values. Then format them with different colors and turn on shade area. 

f(x) High = IF('Normal Distribution'[X]<FLOOR([x-2],1)||'Normal Distribution'[X]>FLOOR([x+2],1),[f(x)],BLANK())

f(x) Medium = IF(('Normal Distribution'[X]>FLOOR([x-2],1)&&'Normal Distribution'[X]<FLOOR([x-1],1))||('Normal Distribution'[X]>FLOOR([x+1],1)&&'Normal Distribution'[X]<FLOOR([x+2],1)),[f(x)],BLANK())

f(x) Low = IF('Normal Distribution'[X]>FLOOR([x-1],1)&&'Normal Distribution'[X]<FLOOR([x+1],1),[f(x)],BLANK())

For the count of Part number shown in Y axis, I don't know how to deal with it. Sorry.

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

Hi Anonymous 

All of f(x) High / Medium / Low measures should be placed in the Line values rather than Column values. You can remove the original f(x) measure from Line values to check the result. They should connect then. Let me know if it works or not.

Regards,

Jing

Hi Anonymous 

You should move them to Line values area below. 

Jing

Hi Anonymous 

Seems close, we need to do some formattings further. 

• Under X axis, change Type from Continuous to Categorical. 
• Right click on the X field in Shared axis and select Show items with no data option.
• On the chart, click ... and select Sort by X and Sort ascending.

And in the formulas, change all > and < signs to >= and <= to connect the boundry values. 

Jing