Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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 

1 REPLY 1
Arul
Super User
Super User

Hi @Anonymous ,

 

Please refer the blog post, you can get some idea on dynamic date table creation in Power Query Editor.

https://blog.enterprisedna.co/setting-up-a-dynamic-startdate-and-enddate-for-power-query-date-tables/ 

 

Thanks,

Arul





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.