Forum Discussion
Frisbeeous
2 years agoFrequent Visitor
Can this Visual be achieved in Power Bi?
I have this report below and I want to reproduce it in Power BI. It displays the name of a rig(item) on the left and there is a visual next to it on the right that displays how many meters that parti...
Frisbeeous
2 years agoFrequent Visitor
| DRILL DATE | RIG ID | METERS |
| 6/2/2021 | 1242 | 11.8 |
| 12/12/2021 | 1319 | 25.1 |
| 5/27/2021 | 1242 | 5.2 |
| 6/8/2021 | 1242 | 16 |
| 6/6/2021 | 1242 | 56.3 |
| 5/30/2021 | 1242 | 22.1 |
| 6/10/2021 | 1242 | 36.9 |
| 12/15/2021 | 1319 | 8.3 |
| 12/17/2021 | 1319 | 16.8 |
| 12/10/2021 | 1319 | 8.2 |
| 12/17/2021 | 1319 | 3 |
| 6/9/2021 | 1242 | 1.7 |
| 6/5/2021 | 1242 | 28 |
| 12/10/2021 | 1319 | 22.3 |
| 12/16/2021 | 1319 | 23.8 |
| 6/8/2021 | 1242 | 26.7 |
| 6/5/2021 | 1242 | 15.2 |
| 12/13/2021 | 1319 | 30 |
| 12/18/2021 | 1319 | 24 |
| 12/11/2021 | 1319 | 24.7 |
| 6/7/2021 | 1242 | 38.6 |
| 12/9/2021 | 1319 | 30 |
| 6/2/2021 | 1242 | 38.8 |
| 12/12/2021 | 1319 | 1.6 |
| 6/9/2021 | 1242 | 36.5 |
| 6/5/2021 | 1242 | 13.7 |
| 12/14/2021 | 1319 | 19.5 |
| 5/27/2021 | 1242 | 22.1 |
| 5/29/2021 | 1242 | 36.8 |
| 5/31/2021 | 1242 | 31.3 |
| 6/1/2021 | 1242 | 40.3 |
| 6/4/2021 | 1242 | 14.5 |
| 7/25/2021 | 1242 | 13.3 |
| 7/25/2021 | 1242 | 3.1 |
| 7/29/2021 | 1242 | 12.5 |
| 6/15/2021 | 1242 | 15 |
| 6/24/2021 | 1242 | 17.3 |
| 6/15/2021 | 1242 | 1.7 |
| 6/18/2021 | 1242 | 42 |
| 6/21/2021 | 1242 | 38.1 |
| 6/19/2021 | 1242 | 2.2 |
| 6/19/2021 | 1242 | 36.8 |
| 7/26/2021 | 1242 | 30 |
| 7/27/2021 | 1242 | 39 |
| 6/21/2021 | 1242 | 0.6 |
| 6/16/2021 | 1242 | 25.1 |
| 6/20/2021 | 1242 | 41 |
| 10/13/2021 | 1242 | 23.6 |
| 10/28/2021 | 1242 | 17.1 |
| 12/4/2021 | 1242 | 13.8 |
| 11/19/2021 | 1242 | 26 |
| 9/7/2021 | 1242 | 16 |
| 8/31/2021 | 1242 | 29.4 |
| 10/23/2021 | 1242 | 7.4 |
| 12/2/2021 | 1242 | 31.4 |
| 12/10/2021 | 1242 | 13.4 |
| 10/30/2021 | 1242 | 32.4 |
| 11/3/2021 | 1242 | 13 |
| 9/3/2021 | 1242 | 35.9 |
| 9/26/2021 | 1242 | 20.2 |
| 9/2/2021 | 1242 | 30.2 |
| 11/14/2021 | 1242 | 21 |
| 10/1/2021 | 1242 | 5.4 |
| 9/8/2021 | 1242 | 30.8 |
| 10/16/2021 | 1242 | 14.3 |
| 12/12/2021 | 1242 | 10.7 |
| 11/11/2021 | 1242 | 14.2 |
| 12/5/2021 | 1242 | 26.6 |
| 9/13/2021 | 1242 | 39 |
| 10/11/2021 | 1242 | 4.3 |
| 9/22/2021 | 1242 | 33 |
| 9/11/2021 | 1242 | 40.5 |
| 12/12/2021 | 1242 | 14.2 |
| 10/29/2021 | 1242 | 4.9 |
| 10/13/2021 | 1242 | 3.3 |
| 11/6/2021 | 1242 | 18 |
| 11/11/2021 | 1242 | 2.5 |
| 11/20/2021 | 1242 | 18.8 |
| 12/3/2021 | 1242 | 3.8 |
| 9/12/2021 | 1242 | 0.5 |
| 10/25/2021 | 1242 | 17.8 |
| 11/13/2021 | 1242 | 30.1 |
| 10/19/2021 | 1242 | 17.6 |
| 9/11/2021 | 1242 | 2 |
| 10/14/2021 | 1242 | 15 |
| 10/20/2021 | 1242 | 9 |
| 11/30/2021 | 1242 | 2.3 |
| 8/30/2021 | 1242 | 22.7 |
| 9/4/2021 | 1242 | 8.5 |
| 8/28/2021 | 1242 | 11.3 |
| 9/24/2021 | 1242 | 4.1 |
| 8/24/2021 | 1242 | 3.1 |
| 11/9/2021 | 1242 | 30.1 |
| 11/4/2021 | 1242 | 10.8 |
| 10/17/2021 | 1242 | 15.3 |
| 9/27/2021 | 1242 | 18.8 |
| 10/6/2021 | 1242 | 25.5 |
| 11/18/2021 | 1242 | 24.7 |
| 8/24/2021 | 1242 | 18.7 |
Here is the sample data. I tried using Ridgeline Plot by Powerviz, it worked somehow but wanted a different way where I could avoid the cost.
- lbendlin2 years agoSuper User
Your sample data is a bit inconclusive. Not sure if Small Multiples can be the answer (depends on the number of rigs) or if this needs a custom visual like Deneb.
What's the meaning of the red dots?
Please provide sample data that fully covers your issue.