cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lucy64
Helper III
Helper III

Help with Line Chart.

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?

 

ProjectLineChart.PNG

1 REPLY 1
Sean
Community Champion
Community Champion

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' )
)

 

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.