Forum Discussion
Anonymous
4 years agoNot 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
- ArulSuper User
Hi Anonymous ,
Please refer the blog post, you can get some idea on dynamic date table creation in Power Query Editor.
Thanks,
Arul