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 ,
I'm Tableau Developer and very new to Power BI and got new request from my team to build a Distribution Chart(Bell Chart) in Power BI.
I have 2 Columns
1. Risk Score : I have created New Column(color legend) as (if risk score is LOw(>0<40) , Medium(>41<70), High(>71<100) by risk Score)
2. Number of Part Number: i have taken count
Kindly help me to build a below chart in power BI
Solved! Go to Solution.
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
Seems close, we need to do some formattings further.
And in the formulas, change all > and < signs to >= and <= to connect the boundry values.
Jing
Use the NORM.DIST() DAX function across your data and plot it in a line chart. NORM.DIST function (DAX) - DAX | Microsoft Docs
Normal Distribution (Gauss Curve) in Power BI (Part I) - YouTube
Hi Ibendlin,
Thank you for quick response.
I have gone through the youtube videos and came up with below chart, but i would like to show in
Y axis as count of Part number & color legend as low, medium and high.
Kindly help me to build it as above sample chart.
For your reference :
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 Jing,
Thank you for your reply.
I just applied f(x) High formula, I'm getting below result.
Please do let me know if it is possible to connect.
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 Jing,
When i applied your formula i got this result.
Hi @Anonymous
You should move them to Line values area below.
Jing
Hi Jing,
Is this correct?
Hi @Anonymous
Seems close, we need to do some formattings further.
And in the formulas, change all > and < signs to >= and <= to connect the boundry values.
Jing
Hi Jing,
you are awesome 🙂 fnally i got the view but is there any way to do the same chart with Variance % & Count of Parts as shown below.
You can consider creating measures to get the Variance % & Count of Parts, and put them in multi-row card visuals.
Power BI Data Visualization Best Practices Part 6: Multi-Row Cards (instructorbrandon.com)
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |