Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

graphic representation

Good morning, I want to display this visual on power bi with the reference right. Do you have any idea. THANK YOU  
Anonymous's avatar
Anonymous
Not applicable
1 year ago

thank you for your feedback, I tried but I can't

I would like to draw the type curve: EXEMPLE

 

Poojara_D12's avatar
Poojara_D12
Super User
1 year ago

Hi Anonymous 

To plot the type curve as a line chart in Power BI using the dataset, follow these steps:

  1. Load Data:

    • Import your data into Power BI, ensuring columns are correctly named (X, Y, and type).

  2. Create a Line Chart:

    • Drag X to the X-axis.
    • Drag Y to the Y-axis.
    • Drag type to the Legend field.

  3. Adjust Formatting:

    • Format the chart to display distinct lines for each type.
    • Make sure the X-axis is set to Continuous for smoother lines.

  4. Check Data:

    • Ensure all type values (e.g., 4, 5, 6) are present and distinct in the chart.

This will display a type curve with a line for each type (4, 5, 6), showing the relationship between X and Y. Let me know if you need additional help!

 

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Please Subscribe my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Poojara_D12 I can do the representation, it's just the line and the colors on the graph, below the line it's green and above it's red

    • Poojara_D12's avatar
      Poojara_D12
      Super User
      1 year ago

      Anonymous 

       

      • Add Y to the Y-axis and X to the X-axis in a Line and Area Chart.
      • Create two DAX measures:
        • Green Area: IF(Y <= Threshold, Y, BLANK()).
        • Red Area: IF(Y > Threshold, Y, BLANK()).
      • Add these measures to the chart and format:
        • Set Green Area to green and Red Area to red under Data Colors.
      • Done! The chart now has green below and red above the line.

      Did I answer your question? Mark my post as a solution, this will help others!

      If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

      Kind Regards,
      Poojara
      Data Analyst | MSBI Developer | Power BI Consultant
      Please Subscribe my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS 

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi Anonymous ,

       

      According to your statement, I think you can refer to this solved post with similar issue like yours.

      I hope it could help you solve your issue.

      For reference:

      Solved: How to create a line chart with range area in the ... - Microsoft Fabric Community

      You can try python to create a visual.

      polygon() 

       

      Best Regards,
      Rico Zhou

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.