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 a dashboard that calculates headcount based on in/out punches. My employer maintains that an employee is active if he she punches in/out within 21 days. (part time large temp workforce). To get this dynamic headcount, I get this every monday when I get a new batch of weekly data.
This calculation:
Hi @Pseifert ,
Could you please provide more details about the measure 4? Does the x-axis of left two charts use the same time field?
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MEasure 4 simply divides the two metrics there. The x-axis uses the same date field from a dimension calendar linked on a date from the punchin/punch out table
Hi @Pseifert ,
When you select the one bar in the top visual, you are actually select the date 9/30, then you select the 9/27 in the buttom visual, so there is no data for "count of color team", result the measure 4 is blank divide number, so measure 4 is blank too. Like following example:
Do you want to count for the team which equal to the selected active headcount?
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello @v-lid-msft,
Yes, I want to take the active head count number that correlates to the week of the active headcount calculation. For instance, the active headcount value from 9/30 should be used for the days within the prior work week..i.e. 09/27. Is there a way to use that 09/30 value rather than filtering for that day? I do not need to select from both charts, I just need the bottom visual to utilize the correct active headcount value.
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 |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |