Forum Discussion

jhauff77060's avatar
jhauff77060
Icon for Advocate II rankAdvocate II
8 years ago

Create a chart showing a mark for each day

Is it possible to create a chart showing a mark for each day, similar to that shown below (created in Tableau)?
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

what is the value for mark? What define the color?

jhauff77060's avatar
jhauff77060
Icon for Advocate II rankAdvocate II
8 years ago

The formula below was used to create the "Flow Status" field (dimension) in Tableau.

 

IF [Flow Hours] = 24 THEN "Full Flow" ELSEIF [Flow Hours] > 0 THEN "Transition" ELSEIF [Flow Hours] = 0 THEN "Shut-in" ELSE "No Report" END

 

The Flow Status field was then placed on the marks card and colored red/yellow/green based on the result (Full Flow/Transition/Shut-in).

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    8 years ago

    seems like you can month on x axis, what is on y axis

    • jhauff77060's avatar
      jhauff77060
      Icon for Advocate II rankAdvocate II
      8 years ago

      In Tableau:

      The Prod Date is on the X axis (exact date, continuous).

      The Well Name is on the Y Axis.

      The Flow Status (Full Flow/Transition/Shut-in) is on the color mark.

       

      Does Power BI support anything like this?

      • jthomson's avatar
        jthomson
        Icon for Solution Sage rankSolution Sage
        8 years ago

        You might need a custom visual - scanning the options something like Heat Streams could work for you perhaps. Not sure whether this can be done out of the box