Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone,
I am learning power bi and each day I learn a new thing. I am currently stuck with histogram custom visual. I currently have 4 different histogram to display the frequency distribution of each of the category. I want to show the all category in one graph as legends and have a bell curve instead of bars. I checked but couldn't find an option to show bell curve.
Also, is it possible to bin the bars explicitly. For example- the fisrt graph for A, the range is 0.03-4.68, 4.68-9.33 and so on. So, instead of having such numbers can we display whole numbers (0-5,5-10...) and this should be for all the categories.
Desired Graph- where each colour represents a category.
Sample data-
ID | Category | num |
1 | C | 2.25 |
2 | C | 4.81 |
3 | A | 5.56 |
4 | C | 2.34 |
5 | C | 4.48 |
6 | A | 14.96 |
7 | A | 1.76 |
8 | C | 1.68 |
9 | C | 9.2 |
10 | C | 1.88 |
11 | C | 2.34 |
12 | B | 9.42 |
13 | A | 29.28 |
14 | A | 3.65 |
15 | C | 4.58 |
16 | A | 4.58 |
17 | C | 10.01 |
18 | A | 34.46 |
19 | C | 7.99 |
20 | C | 1.77 |
21 | A | 1.77 |
22 | C | 0.15 |
23 | A | 0.15 |
24 | A | 14.65 |
25 | C | 8.21 |
26 | C | 4.3 |
27 | C | 5.96 |
28 | C | 2.3 |
29 | C | 1.87 |
30 | C | 4.08 |
31 | C | 4.29 |
32 | C | 4.69 |
33 | C | 3.78 |
34 | A | 3.78 |
35 | C | 4.58 |
36 | C | 11.08 |
37 | A | 12.29 |
38 | A | 9.27 |
39 | C | 11.04 |
40 | A | 11.06 |
41 | C | 1.86 |
42 | A | 8.85 |
43 | C | 2.27 |
44 | A | 12.54 |
45 | A | 4.42 |
46 | B | 9.42 |
47 | B | 30.62 |
48 | B | 30.4 |
49 | B | 8.58 |
50 | D | 9.9 |
51 | B | 26.7 |
52 | B | 16.92 |
53 | B | 12.81 |
54 | D | 11.02 |
55 | B | 17.79 |
56 | B | 6.98 |
57 | B | 7.69 |
58 | B | 19.93 |
59 | B | 30.55 |
60 | B | 8.02 |
61 | D | 11.27 |
62 | B | 8.08 |
63 | B | 13.07 |
64 | D | 10.68 |
65 | B | 22.65 |
66 | B | 25.52 |
67 | D | 7.65 |
68 | B | 17.24 |
69 | D | 10.81 |
70 | D | 10.68 |
71 | B | 8.12 |
72 | B | 5.83 |
73 | B | 26.07 |
74 | D | 11.06 |
75 | D | 10.74 |
76 | D | 10.91 |
Any help would be much appreciated.
hI @Anonymous ,
You can have a look at these blogs
https://www.youtube.com/watch?v=5bPVMFrUnrU
Regards,
Harsh Nathani
Hi @harshnathani ,
I am currently able to bin the bars using below DAX and used a stacked column chart. But I am not able to get around with having a bell curve as per my requirement. Thank you for sharing the links.
User | Count |
---|---|
51 | |
38 | |
20 | |
14 | |
13 |
User | Count |
---|---|
98 | |
71 | |
29 | |
18 | |
13 |