Forum Discussion

Frisbeeous's avatar
Frisbeeous
Frequent Visitor
2 years ago

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 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

Custom Visualization

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    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-Forum/ba-p/963216
    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/1447523

  • Frisbeeous's avatar
    Frisbeeous
    Frequent Visitor
    2 years ago
    DRILL DATERIG IDMETERS
    6/2/2021124211.8
    12/12/2021131925.1
    5/27/202112425.2
    6/8/2021124216
    6/6/2021124256.3
    5/30/2021124222.1
    6/10/2021124236.9
    12/15/202113198.3
    12/17/2021131916.8
    12/10/202113198.2
    12/17/202113193
    6/9/202112421.7
    6/5/2021124228
    12/10/2021131922.3
    12/16/2021131923.8
    6/8/2021124226.7
    6/5/2021124215.2
    12/13/2021131930
    12/18/2021131924
    12/11/2021131924.7
    6/7/2021124238.6
    12/9/2021131930
    6/2/2021124238.8
    12/12/202113191.6
    6/9/2021124236.5
    6/5/2021124213.7
    12/14/2021131919.5
    5/27/2021124222.1
    5/29/2021124236.8
    5/31/2021124231.3
    6/1/2021124240.3
    6/4/2021124214.5
    7/25/2021124213.3
    7/25/202112423.1
    7/29/2021124212.5
    6/15/2021124215
    6/24/2021124217.3
    6/15/202112421.7
    6/18/2021124242
    6/21/2021124238.1
    6/19/202112422.2
    6/19/2021124236.8
    7/26/2021124230
    7/27/2021124239
    6/21/202112420.6
    6/16/2021124225.1
    6/20/2021124241
    10/13/2021124223.6
    10/28/2021124217.1
    12/4/2021124213.8
    11/19/2021124226
    9/7/2021124216
    8/31/2021124229.4
    10/23/202112427.4
    12/2/2021124231.4
    12/10/2021124213.4
    10/30/2021124232.4
    11/3/2021124213
    9/3/2021124235.9
    9/26/2021124220.2
    9/2/2021124230.2
    11/14/2021124221
    10/1/202112425.4
    9/8/2021124230.8
    10/16/2021124214.3
    12/12/2021124210.7
    11/11/2021124214.2
    12/5/2021124226.6
    9/13/2021124239
    10/11/202112424.3
    9/22/2021124233
    9/11/2021124240.5
    12/12/2021124214.2
    10/29/202112424.9
    10/13/202112423.3
    11/6/2021124218
    11/11/202112422.5
    11/20/2021124218.8
    12/3/202112423.8
    9/12/202112420.5
    10/25/2021124217.8
    11/13/2021124230.1
    10/19/2021124217.6
    9/11/202112422
    10/14/2021124215
    10/20/202112429
    11/30/202112422.3
    8/30/2021124222.7
    9/4/202112428.5
    8/28/2021124211.3
    9/24/202112424.1
    8/24/202112423.1
    11/9/2021124230.1
    11/4/2021124210.8
    10/17/2021124215.3
    9/27/2021124218.8
    10/6/2021124225.5
    11/18/2021124224.7
    8/24/2021124218.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.

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      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.

  • Frisbeeous's avatar
    Frisbeeous
    Frequent Visitor
    2 years ago

    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.