cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Scatter plot with customized boundary lines impossible?

Dear community,

I have created a customer-specific visual in Excel and would like to display it in Power BI. Using a slicer, I can select the customer and display the chart with all 35,000 time steps. Everything works great, I'm just having trouble adding a boundary line. Below is the data shown. I look forward to your suggestions!

Data set:

 date x value y value 01.01.2024 00:00:00 84 -91 01.01.2024 00:15:00 -42 34 .. .. ..

Boundaries for the line chart:

 x threshold y threshold -60 60 -30 20 30 20 90 90

Soultion with Excel:

Solution in Excel

1 ACCEPTED SOLUTION
Frequent Visitor

I have solved the problem with three diagrams. Two line plots showing the boundary values and a scatter plot with the values. I overlapped all the plots and stored the same functions in the axis settings.

3 REPLIES 3
Frequent Visitor

I have solved the problem with three diagrams. Two line plots showing the boundary values and a scatter plot with the values. I overlapped all the plots and stored the same functions in the axis settings.

Community Support

Hi @jb257

The concept of adding boundary lines is different in power bi compared to excel.

Boundary lines seen in Excel are not presented in the same way in Power BI visual objects.

This appears to be a range that can be defined based on the maximum and minimum values of the x-threshold and y-threshold.

Here is the result.

Regards,

Nono Chen

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

Frequent Visitor

Hi @v-nuoc-msft ,

Thank you very much for your answer. I have the problem that I only need the constant lines between two specific data points (x1/y1) and (x2/y2). Between two other data points I need a line with gradient (see Excel solution above). I don't think you can set such limits with Power BI.

Regards,

JB

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors