topic Re: Binning the histogram and to display different legends in same graph in DAX Commands and Tips

Binning the histogram and to display different legends in same graph

Anonymous — Tue, 16 Jun 2020 01:14:44 GMT

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.

Re: Binning the histogram and to display different legends in same graph

Anonymous — Tue, 16 Jun 2020 07:01:42 GMT

hI Anonymous ,

You can have a look at these blogs

https://www.mssqltips.com/sqlservertip/4076/create-bell-curve-and-histogram-with-power-bi-desktop-using-dax/

https://www.youtube.com/watch?v=5bPVMFrUnrU

Regards,

Harsh Nathani

Re: Binning the histogram and to display different legends in same graph

Anonymous — Wed, 17 Jun 2020 12:01:52 GMT

Hi Anonymous ,

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.

Range Ten = var temp= SUM(Table[Num]) return

if(temp<=5,"0-5",if(AND(temp>5,temp<=10),"5-10",if(AND(temp>10,temp<=15),"10-15", if(AND(temp>15,temp<=20),"15-20", if(AND(temp>20,temp<=25),"20-25", if(AND(temp>25,temp<=30),"25-30", if(AND(temp>30,temp<=35),"30-35",">35")))))))

Regards,

Supriya