Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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 particular Rig drilled within the year.
I have the Rig names, the meters they drilled for each day, and the date within the year they drilled.
Is it possible to achieve something like the Visual below? And what would be the process to do so?
Daily Rig Meters for each Rig for the year
Thank you guys. I have been able to resolve it using Sparkline by OKViz. It gave me a similar visual that I wanted and it's free.
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.
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.
Pretty sure Deneb can do that.
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...