Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Need Dashboard

Hi,

am new one for power bi.

i have a data like below. i need a simple dashboard. mainly i need to display
total average. the other column should be filter. at any combination i will filter

Date	Name	ID	Check	Val1	Val2	Val3	TOTAL	AVERAGE	Finding	Type
01/01/2022	ABC	111111	O		1		1	33%	Find1	O
01/01/2022	ABC	111112	E	1		1	2	67%	Find2	O
03/10/2021	ABC	111113	E				0	0%	Clean	O
03/10/2021	ABC	111114	E	1	1	1	3	100%	Find3	O
03/10/2021	ABC	111115	E				0	0%	Clean	O
01/10/2021	ABC	111116	I		1		1	33%	Find1	I
02/10/2021	ABC	111117	I	1		1	2	67%	Find2	I
02/10/2021	ABC	111118	I				0	0%	Clean	I
03/10/2021	ABC	111119	I	1	1	1	3	100%	Find3	I
03/10/2021	ABC	111120	N				0	0%	Clean	I
01/01/2022	XXX	111121	O		1		1	33%	Find1	O
01/01/2022	XXX	111122	E	1		1	2	67%	Find2	O
03/10/2021	XXX	111123	E				0	0%	Clean	O
03/10/2021	XXX	111124	E	1	1	1	3	100%	Find3	O
03/10/2021	XXX	111125	E				0	0%	Clean	O
01/10/2021	XXX	111126	I		1		1	33%	Find1	I
02/10/2021	XXX	111127	I	1		1	2	67%	Find2	I
02/10/2021	XXX	111128	I				0	0%	Clean	I
03/10/2021	XXX	111129	I	1	1	1	3	100%	Find3	I
03/10/2021	XXX	111130	N				0	0%	Clean	I


based on that the average should be display.
also i need to drilldown on date column

 

Thanks