topic Re: graphic representation in DAX Commands and Tips

graphic representation

Anonymous — Fri, 22 Nov 2024 09:10:02 GMT

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

Re: graphic representation

Poojara_D12 — Fri, 22 Nov 2024 10:29:35 GMT

Hi Anonymous

To replicate the visual in Power BI:

Use a Line Chart.
Add your data for X-axis (e.g., Date) and Y-axis (metric).
Use Analytics to add reference lines (constant or trend lines).
Format the lines (color, style, width) in the Format pane.
Adjust background and gridlines for a cleaner look.
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

Re: graphic representation

Anonymous — Fri, 22 Nov 2024 10:45:59 GMT

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

I would like to draw the type curve: EXEMPLE

Re: graphic representation

Poojara_D12 — Fri, 22 Nov 2024 10:48:46 GMT

Hi Anonymous

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

Load Data:
- Import your data into Power BI, ensuring columns are correctly named (X, Y, and type).
Create a Line Chart:
- Drag X to the X-axis.
- Drag Y to the Y-axis.
- Drag type to the Legend field.
Adjust Formatting:
- Format the chart to display distinct lines for each type.
- Make sure the X-axis is set to Continuous for smoother lines.
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

Re: graphic representation

Anonymous — Fri, 22 Nov 2024 10:52:42 GMT

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

Re: graphic representation

Poojara_D12 — Fri, 22 Nov 2024 10:55:11 GMT

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

Re: graphic representation

Anonymous — Mon, 25 Nov 2024 02:18:30 GMT

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.