The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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...