Visualize Plan vs Actual in Power BI

primasatria

New member
Joined
Jul 19, 2021
Messages
1
Reaction score
0
Points
0
Excel Version(s)
Office 365
[FONT=&quot]Hi Folks,[/FONT]

[FONT=&quot]I am newbie in Microsoft Power Bi.[/FONT]
[FONT=&quot]I have a data in Excel, I have only 3 columns.[/FONT]
[FONT=&quot]1st columns (A): plan date (date)[/FONT]
[FONT=&quot]2nd column (B): actual date (date)[/FONT]
[FONT=&quot]3rd column (C): System number (string)[/FONT]

[FONT=&quot]Within April 2021, we have a plan to finish 11 system numbers[/FONT]
[FONT=&quot]And within April 2021, we achieve 30 system numbers, some is part of the plan in May 2021, June 2021, August 2021 (ahead), as below:[/FONT]
[FONT=&quot]April 2021: finish 10 system numbers, finished in April 2021[/FONT]
[FONT=&quot]May 2021: finish 7 system numbers, finished in April 2021[/FONT]
[FONT=&quot]June 2021: finish 9 system numbers, finished in April 2021[/FONT]
[FONT=&quot]August 2021: finish 4 system numbers, finished in April 2021[/FONT]

[FONT=&quot]When I to insert a pivot table in Excel, the result of April 2021 is Plan = 11 and Actual = 10[/FONT]
[FONT=&quot]What we want of the result of April 2021 is Plan = 11 and Actual = 30[/FONT]
[FONT=&quot]Is is possible to do it in PivotTable or Power Bi? if I used Countif function, I could get as what I expected. But not in PivotTable or Power Bi[/FONT]

[FONT=&quot]I really appreciate it if someone could help me.[/FONT]

[FONT=&quot]Thank you[/FONT]
[FONT=&quot]prima - Indonesia[/FONT]
 
consider sending the actual table of data (sanitized if needed) otherwise we have to guess at building it. Not a good use of anyone's time
 
Back
Top