Need to build a graph based on percentage of total per week not grand total

[ReutB]

Hi,
We have a report table, each line contains recourses, task and hours per week.
We need your help to build a graph of specific task effort based on the percentage of effort per week, not the percentage of the total effort.
We would also like to add on the background the division to preferred percentages by color (red, yellow, green)
Thanks in advance,
Reut

[amitchandak]

@ReutB ,a ssume you have a week in visual and your date table has that week

with week rank column you in date table

Week Rank = RANKX(all('Date'),'Date'[Week Start date],,ASC,Dense)
OR
Week Rank RANKX(all('Date'),'Date'[Year Week],,ASC,Dense) //YYYYWW format

you can a measure with help from week rank or year week or week start date

This Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])))

% of week =  divide( sum('Table'[Qty]), [This week])