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.
Hello! I have two tables. The first table hast two columns: timestamp and power being consumed over time. The second table has two columns too: timestamp and state of the device (consuming power =3, not consuming power =2). This means both tables relate to the same device. I want to create a graph with two line charts over time. But when I add time and value (twice) to the graph, one of them just stays at 0 the whole time. Any help?
Solved! Go to Solution.
Hi i tested it for you and believe you do everything right.
My quess is either there is no relationship between the 2 tables. In that case add the 2nd timestamp to Axis aswell. OR the values of Power consumption overtime are so high it looks like the 2's and 3's are all the same.
I used these tables to test:
Timestamp | Power consumed |
1 | 1 |
2 | 3 |
3 | 4 |
4 | 2 |
5 | 3 |
6 | 1 |
7 | 4 |
8 | 5 |
9 | 7 |
10 | 1 |
and
Timestamp | State of device |
1 | 2 |
2 | 3 |
3 | 2 |
4 | 2 |
5 | 3 |
6 | 3 |
7 | 2 |
8 | 3 |
9 | 2 |
10 | 3 |
Result
if this is incorrect, please share some sample data i can correct my answer with.
Goodluck! 🙂
Hi i tested it for you and believe you do everything right.
My quess is either there is no relationship between the 2 tables. In that case add the 2nd timestamp to Axis aswell. OR the values of Power consumption overtime are so high it looks like the 2's and 3's are all the same.
I used these tables to test:
Timestamp | Power consumed |
1 | 1 |
2 | 3 |
3 | 4 |
4 | 2 |
5 | 3 |
6 | 1 |
7 | 4 |
8 | 5 |
9 | 7 |
10 | 1 |
and
Timestamp | State of device |
1 | 2 |
2 | 3 |
3 | 2 |
4 | 2 |
5 | 3 |
6 | 3 |
7 | 2 |
8 | 3 |
9 | 2 |
10 | 3 |
Result
if this is incorrect, please share some sample data i can correct my answer with.
Goodluck! 🙂
Hi! First of all, thanks a lot for your help! You are right, the problem is that the 3 and 2 look the same because the power values are so high. Do you know how I can add a second Y-Axis so that the 3 and the 2 are visible? Thanks!
you could use a bar + line chart for that.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |