Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone, help is needed 😞
I need to create a line chart that shows time vs depth for a digging/drilling process.
All I have now is follwing columns:
- step No: 1,2,3,...
- time in hrs: time it takes to drill the hole from one depth to another
- depth from: starting depth
- depth to: end depth
- activity: type of activity, where drilling is the main activity and thes rest is secondary (like replacing tools, waiting on weather).
Left is my current table. Right is how it should look like, with the line chart.
Cells marked by yellow indicate secondary, non-drilling activities (replacing and waiting on weather) and should be shown on the line chart as flat lines since the depth doesn't change.
The actual table contains many more rows, so not possible to edit it manually.
Should I start with two measures?
Thanks in advance!
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
@AllisonKennedy Hi Alison, thanks for your promt comment. I've added some annotations to the picture.
@Alex_0201 Thanks, that's exactly what I thought. You'll need to add that first row in there as a data point, but otherwise focus on the blue and red boxes in your left picture.
AS CALCULATED COLUMN:
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
@AllisonKennedy the formula
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
@AllisonKennedy Nice!
1. so I start with creating a new measure or rather a new column?
2. Regarding the first line in the new column the green boxes), it might as well start with step No 1. What's important is that the time starts at 0 and the depth is copied from the first line in the original tabel (step No 1), or picked as the shallowest depth (30 m).
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |