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 am using a line chart to show manpower required for future projects. I would like to incorporate a line which shows current manpower. Which is a field not currently used in the chart (EmployeeCount). I would like it to show like the Constant Line I added. Can this be done?
What does the Employee count column represent?
We need to know what kind of aggregation to perform on it?
Generally your formula should look something like this...
Total Employees = CALCULATE ( DISTINCTCOUNT ( 'Table'[EmployeeID] ), ALLSELECTED ( 'CalendarTable' ) )
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 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |