normal distribution

[Sujit_Thakur]

Dear all , following is my dummy data

Date	time	Name	Actual	Capacity	%overload	%Fix overload
14-09-20	02:00	BOX A	2030	4000	51%	51%
14-09-20	03:00	BOX A	342	4000	9%	9%
14-09-20	04:30	BOX A	2000	4000	50%	50%
14-09-20	11:00	BOX A	-342	4000	-9%	0%
14-09-20	13:00	BOX A	4523	4000	113%	113%
14-09-20	16:00	BOX A	6342	4000	159%	120%
14-09-20	20:00	BOX A	12456	4000	311%	120%
14-09-20	02:00	BOX B	7235	3000	241%	120%
14-09-20	03:00	BOX B	-2345	3000	-78%	0%
14-09-20	04:30	BOX B	5235	3000	175%	120%
14-09-20	11:00	BOX B	1245	3000	42%	42%
14-09-20	13:00	BOX B	53	3000	2%	2%
14-09-20	16:00	BOX B	356	3000	12%	12%
14-09-20	20:00	BOX B	1567	3000	52%	52%

Capacity is what weight box is designed to carry , while actual is how much weight it is carrying .
% overload is overload percent and %fix overload is nothing but a column where any overload % < 0 will show 0 and any overload% > 120% will show 120%.
I want to make seperate normal distribution curve for box a and box b .

need help 
@Greg_Deckler @amitchandak @nickyvv 


Regards ,
Sujit

[nickyvv]

Hi @Anonymous,

providing proper dummy data (either in JSON format or a PBIX) would help in solving your problem.

[Sujit_Thakur]

Dear @nickyvv ,
https://drive.google.com/file/d/1wGMKUwvP-QHwQxt1seREIYlIGO2wJyAS/view?usp=sharing
this is my pbix  i have just loaded data model.
what i desire to attain is two seperate normal distribution tile  of %overload_fix column for  the boxes(box a and box b)
box is name in field 'name '

need help

[Sujit_Thakur]

@nickyvv  please help

[Sumanth_23]

hi @Sujit_Thakur - Take a look if the below article helps with what you are trying to achieve - you can create a histogram to show the distribution of records for box A and box B

https://www.mssqltips.com/sqlservertip/4076/power-bi-histogram-example-using-dax/

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

[Sujit_Thakur]

Ok @nickyvv 

Will be providing data model in 5 min