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?