Skip to main content
cancel
Showing results for 
Search instead 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

Reply
jb257
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:0084-91
01.01.2024 00:15:00-4234
......

Boundaries for the line chart:

x threshold  y threshold  
-6060
-3020
3020
9090

Soultion with Excel:

Solution in ExcelSolution in Excel

1 ACCEPTED SOLUTION
jb257
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.

View solution in original post

3 REPLIES 3
jb257
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.

v-nuoc-msft
Community Support
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.

 

You can add in "Analytics".

 

vnuocmsft_0-1710314992467.png

 

vnuocmsft_1-1710315152868.png

 

vnuocmsft_3-1710315177175.png

 

Here is the result.

 

vnuocmsft_4-1710315263398.png

 

Regards,

Nono Chen

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

 

 

 

 

 

 

 

 

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

Helpful resources

Announcements
Europe Fabric Conference

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.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

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

August Carousel

Fabric Community Update - August 2024

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