March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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. | Planned | Arrival | Unpacking |
1 | Planned | 03.11.2020 | 03.11.2020 |
4 | Planned | 03.11.2020 | 03.11.2020 |
5 | Planned | 03.11.2020 | 03.11.2020 |
7 | Planned | 03.11.2020 | 03.11.2020 |
8 | Planned | 03.11.2020 | 04.11.2020 |
9 | Planned | 03.11.2020 | 04.11.2020 |
10 | Planned | 03.11.2020 | 04.11.2020 |
11 | Planned | 04.11.2020 | 04.11.2020 |
14 | Planned | 04.11.2020 | 04.11.2020 |
12 | Planned | 04.11.2020 | 05.11.2020 |
15 | Planned | 04.11.2020 | 05.11.2020 |
16 | Planned | 04.11.2020 | 05.11.2020 |
17 | Planned | 04.11.2020 | 05.11.2020 |
13 | Planned | 04.11.2020 | 06.11.2020 |
18 | Planned | 04.11.2020 | 06.11.2020 |
19 | Planned | 05.11.2020 | 06.11.2020 |
6 | Planned | 05.11.2020 | 06.11.2020 |
20 | Planned | 06.11.2020 | 06.11.2020 |
21 | Planned | 06.11.2020 | 07.11.2020 |
3 | Planned | 06.11.2020 | 07.11.2020 |
2 | Planned | 07.11.2020 | 07.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. | Planned | Arrival | Unpacking |
1 | Actual | 03.11.2020 | 04.11.2020 |
4 | Actual | 04.11.2020 | |
5 | Actual | 03.11.2020 | 04.11.2020 |
7 | Actual | 03.11.2020 | 04.11.2020 |
8 | Actual | 03.11.2020 | |
9 | Actual | 03.11.2020 | |
10 | Actual | 03.11.2020 | |
11 | Actual | 05.11.2020 | |
14 | Actual | 04.11.2020 | 05.11.2020 |
12 | Actual | 04.11.2020 | 05.11.2020 |
15 | Actual | 04.11.2020 | 05.11.2020 |
16 | Actual | ||
17 | Actual | 04.11.2020 | 05.11.2020 |
13 | Actual | 04.11.2020 | 05.11.2020 |
18 | Actual | ||
19 | Actual | 05.11.2020 | 06.11.2020 |
6 | Actual | 05.11.2020 | 06.11.2020 |
20 | Actual | 06.11.2020 | 06.11.2020 |
21 | Actual | ||
3 | Actual | 07.11.2020 | |
2 | Actual | 07.11.2020 | 07.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:
Would really appreciate some help in how i can achieve that.
Thanks in advance
Solved! Go to Solution.
@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
Works like a charm, thank you very much!
@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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
121 | |
98 | |
86 | |
69 | |
61 |
User | Count |
---|---|
138 | |
121 | |
109 | |
99 | |
96 |