Skip to main content
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

graphic representation

Good morning,
I want to display this visual on power bi with the reference right.
Do you have any idea.
THANK YOU
Lebron45_1-1732266459709.png

 

6 REPLIES 6
Poojara_D12
Super User
Super User

Hi @Anonymous 

 

To replicate the visual in Power BI:

  1. Use a Line Chart.
  2. Add your data for X-axis (e.g., Date) and Y-axis (metric).
  3. Use Analytics to add reference lines (constant or trend lines).
  4. Format the lines (color, style, width) in the Format pane.
  5. Adjust background and gridlines for a cleaner look.
  6. Customize the legend and titles as needed.

 

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 

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 - Proud to be a Super User
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS
Anonymous
Not applicable

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

I would like to draw the type curve: EXEMPLE

Lebron45_0-1732272302926.png

 

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 

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 - Proud to be a Super User
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS
Anonymous
Not applicable

@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

@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 

 

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 - Proud to be a Super User
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS
Anonymous
Not applicable

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.

Helpful resources

Announcements
November Fabric Update Carousel

Fabric Monthly Update - November 2025

Check out the November 2025 Fabric update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Users online (25)