Present Borehole Depth data as a visual Bar Graph

[Crimzo]

Hi All,

I was wondering if someone could help me with the following, sorry if this has been posted before.

I am trying to present borehole geology i.e. sand unit 1 and clay unit 2 on a bar graph with depth (y axis) per location (x-axis). I.e. for Borehole 1 show in red Unit1 from 0m to 1m then Unit 2 in yellow from 1m to 2m, then for Borehole 2 show Unit 1 at 0m to 5m, and so on. However, I am struggling to do this on a clustered bar graph as it always Sums or averages my depth data.

I have an example of what I after in the following link on the right in the first few seconds, but this is a custom visual. An example of the data I would like to present is attached below. https://www.youtube.com/watch?v=2QNKP-CX4Dc 

Any help would be much appreciated!

Location	Depth From [m]	Depth to [m]	Unit
BH1	0	1	Unit1
BH1	1	2	Unit2
BH2	0	5	Unit1
BH2	5	10	Unit3
BH2	10.5	12.2	Unit2
CPT1	0	2.2	Unit3
CPT1	2.2	3.4	Unit2
CPT1	3.4	5	Unit1
CPT1	5	6	Unit1

[Anonymous]

Hi, could you find any way to do it?

[Mostafa_Elsawy]

did you find solution ?????

[v-yingjl]

Hi @Crimzo ,

I'm afraid that clustered chart could not achieve the same result in power bi becasue you have not the same standard which can be used to do some calculations.

Since it is a custom visual, I think you need to contact the author of it.

https://www.discoverei.com/products/bore-log 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.