Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have visualisation show workers by weekly hours, but I want my visual to display on worker with more than 72Hrs per week.
Please see attached and am getting my sum of hours from column worked_Hours.
Solved! Go to Solution.
Hi @oolamide85
Try again this.
Regards,
Cherie
Hi @oolamide85
You may try to create a measure like below to get the visual as requested.
Measure = VAR workhours = CALCULATE ( SUM ( Table4[worked hours] ) ) RETURN IF ( workhours >= 72, workhours )
Regards,
Cherie
The Column workhours are daily worked hours and I have the sum of worked hours in week in report view which is fine, but I want the report to show only worked who have worked more than 72hrs .
Hi @oolamide85
Here is the sample file. If it is not your case, please share your data sample file. You can upload it to OneDrive or Dropbox and post the link here.
Regards,
Cherie
unable to download the file.
Thanks.
Hi @oolamide85
Try again this.
Regards,
Cherie
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |