cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Line chart that sums count of values by date.

Hey,

I'm having an issue creating a line chart that shows the progress of achieving certain statuses. First however let me explain the situation.

I have two tables, the first table called ,,Planned" shows when a machine i supposed to achieve certain status

MC No.PlannedArrivalUnpacking
1Planned03.11.202003.11.2020
4Planned03.11.202003.11.2020
5Planned03.11.202003.11.2020
7Planned03.11.202003.11.2020
8Planned03.11.202004.11.2020
9Planned03.11.202004.11.2020
10Planned03.11.202004.11.2020
11Planned04.11.202004.11.2020
14Planned04.11.202004.11.2020
12Planned04.11.202005.11.2020
15Planned04.11.202005.11.2020
16Planned04.11.202005.11.2020
17Planned04.11.202005.11.2020
13Planned04.11.202006.11.2020
18Planned04.11.202006.11.2020
19Planned05.11.202006.11.2020
6Planned05.11.202006.11.2020
20Planned06.11.202006.11.2020
21Planned06.11.202007.11.2020
3Planned06.11.202007.11.2020
2Planned07.11.202007.11.2020

So for example, on 03.11.2020 machines 1,4,5,7,8,9,10 are supposed to achieve status ,,Arrival", and machines 1,4,5,7 are supposed to achieve status ,,unpacking"

Second table is the ,,actual' table which shows what statuses were achieved and when. If a record is blank then that means this status havent been achieved by the machine yet

MC No.PlannedArrivalUnpacking
1Actual03.11.202004.11.2020
4Actual 04.11.2020
5Actual03.11.202004.11.2020
7Actual03.11.202004.11.2020
8Actual03.11.2020 
9Actual03.11.2020 
10Actual03.11.2020 
11Actual 05.11.2020
14Actual04.11.202005.11.2020
12Actual04.11.202005.11.2020
15Actual04.11.202005.11.2020
16Actual  
17Actual04.11.202005.11.2020
13Actual04.11.202005.11.2020
18Actual  
19Actual05.11.202006.11.2020
6Actual05.11.202006.11.2020
20Actual06.11.202006.11.2020
21Actual  
3Actual 07.11.2020
2Actual07.11.202007.11.2020

My goal is to make a line chart which would show two lines

a) A line of how many statuses have actually been achieved by a date (not for each day, a sum of how many were achieved by that day)

b) Same line, but showing the plans

Each status would have a separate line chart.

For example, the ,,Arrival" chart would look something like this: 

8e1a32243bc5072bb111a754fe9b1d3c.png

Would really appreciate some help in how i can achieve that.

 

Thanks in advance

 

1 ACCEPTED SOLUTION
Super User IV
Super User IV

@jellyjoe , Not very clear. But someting like this calculate(sum(Table[MC No]), filter(Allselected(Table), Table[Arrival] <= max(Table[Arrival]) && Table[Planned] =max(Table[Planned])))

and actual/planned as measure or legend



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

2 REPLIES 2
Regular Visitor

Works like a charm, thank you very much!

Super User IV
Super User IV

@jellyjoe , Not very clear. But someting like this calculate(sum(Table[MC No]), filter(Allselected(Table), Table[Arrival] <= max(Table[Arrival]) && Table[Planned] =max(Table[Planned])))

and actual/planned as measure or legend



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors