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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Jameel
Regular Visitor

Actual vs target Area chart

  i have table where each title's actual and completed date.Target date will be the end of the week .Actual date will within or more than the target date.

95FD4AB6-0293-4357-A0D4-C27F3E62B4B4.jpeg

I want to create a area chart showing actual vs target for each week like below

83AF54B2-D159-46F9-AACD-37B7E5C28978.jpeg

 Please help to solve this.

1 ACCEPTED SOLUTION
v-zhangti
Community Support
Community Support

Hi, @Jameel 

 

You can try the following methods. Create a new date table.

Week = RIGHT(Year([Date]),2)&"WK"&WEEKNUM([Date],2)

vzhangti_0-1679909006355.png

Column:

Actual Week = IF([Actual Date]<>BLANK(),RIGHT(Year([Actual Date]),2)&"WK"&WEEKNUM([Target Date],2))
Target Week = RIGHT(Year([Target Date]),2)&"WK"&WEEKNUM([Target Date],2)

vzhangti_1-1679909057324.png

Measure:

Planned = CALCULATE(COUNT('Table'[S.No]),FILTER(ALL('Table'),[Target Week]=SELECTEDVALUE('Date'[Week])))
Delivered = CALCULATE(COUNT('Table'[S.No]),FILTER(ALL('Table'),[Actual Week]=SELECTEDVALUE('Date'[Week])))

vzhangti_2-1679909111281.png

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

4 REPLIES 4
v-zhangti
Community Support
Community Support

Hi, @Jameel 

 

You can try the following methods. Create a new date table.

Week = RIGHT(Year([Date]),2)&"WK"&WEEKNUM([Date],2)

vzhangti_0-1679909006355.png

Column:

Actual Week = IF([Actual Date]<>BLANK(),RIGHT(Year([Actual Date]),2)&"WK"&WEEKNUM([Target Date],2))
Target Week = RIGHT(Year([Target Date]),2)&"WK"&WEEKNUM([Target Date],2)

vzhangti_1-1679909057324.png

Measure:

Planned = CALCULATE(COUNT('Table'[S.No]),FILTER(ALL('Table'),[Target Week]=SELECTEDVALUE('Date'[Week])))
Delivered = CALCULATE(COUNT('Table'[S.No]),FILTER(ALL('Table'),[Actual Week]=SELECTEDVALUE('Date'[Week])))

vzhangti_2-1679909111281.png

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

v-zhangti
Community Support
Community Support

Hi, @Jameel 

 

What is the Y-axis in the output you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I want actual and target count on each week

If i need to add extra data to the existing data to get the result.please let mw know 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.