Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
@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])
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |