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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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...
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.