undefined

[benz-fsproduce]

Hi, I am currently trying prepare a graph for it to compare headcounts in 2022 and 2023. I have an area chart that shows the head count goal, current position filled, and critical. The headcount goal shows our companies maximum capacity, the current positions filled shows how many employees we currently have, and critical shows where we need to work better on recruiting. My coworker wants to set the graph up so that 2022 current positions filled and 2023 current postions filled are seperate lines. I can't seem to get this right. I have pasted my excel data and took screen shots of what I am talking about.

Date	Headcount Goal	OK	Critical	Current Positions Filled
1/5/2022	252	212-251	211	242
1/11/2022	252	212-251	211	241
1/19/2022	252	212-251	211	234
1/26/2022	252	212-251	211	237
1/31/2022	252	212-251	211	239
2/7/2022	252	212-251	211	237
2/16/2022	252	212-251	211	234
2/23/2022	252	212-251	211	231
3/2/2022	252	212-251	211	229
3/7/2022	252	212-251	211	231
3/16/2022	252	212-251	211	229
3/23/2022	252	212-251	211	229
3/30/2022	252	212-251	211	228
4/6/2022	252	212-251	211	228
4/13/2022	252	212-251	211	225
4/20/2022	252	212-251	211	214
4/27/2022	252	212-251	211	220
5/3/2022	259	219-258	218	220
5/11/2022	259	219-258	218	221
5/18/2022	259	219-258	218	205
5/24/2022	259	219-258	218	228
6/1/2022	259	219-258	218	212
6/8/2022	259	219-258	218	215
6/15/2022	259	219-258	218	206
6/22/2022	259	219-258	218	210
6/28/2022	259	219-258	218	208
7/6/2022	259	219-258	218	207
7/12/2022	259	219-258	218	218
7/19/2022	259	219-258	218	220
7/27/2022	259	219-258	218	225
8/2/2022	261	220-260	219	216
8/9/2022	261	220-260	219	221
8/16/2022	261	220-260	219	209
8/24/2022	261	220-260	219	216
8/31/2022	261	220-260	219	212
9/7/2022	261	220-260	219	216
9/14/2022	261	220-260	219	220
9/21/2022	261	220-260	219	211
9/28/2022	261	220-260	219	209
10/5/2022	261	220-260	219	231
10/12/2022	261	220-260	219	228
10/19/2022	261	220-260	219	226
10/25/2022	261	220-260	219	231
11/1/2022	261	220-260	219	234
11/8/2022	261	220-260	219	235
11/15/2022	261	220-260	219	230
11/22/2022	261	220-260	219	229
11/29/2022	261	220-260	219	231
12/6/2022	261	220-260	219	233
12/13/2022	261	220-260	219	230
12/20/2022	261	220-260	219	234
12/27/2022
1/5/2023	261	220-260	219	250
1/12/2023	261	220-260	219	241
1/19/2023	261	220-260	219	246

I do not need the "OK" column in this graph. I appreciate the help.

[Shaurya]

Hi @benz-fsproduce,

You can create separate measures for the years like:

Current Positions 2022 = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Year=]=2022))

But I'm curious. You will still have the month year in the X-Axis. Are you planning to show the numbers only for months on the axis with lines for different years? Because otherwise it seems like a hassle when you have data for several years.

Did I answer your question? Mark this post as a solution if I did!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI

[benz-fsproduce]

I want just the month on the x-axis, but when I do this happens.