- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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".
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
10-28-2024 11:32 AM | |||
07-03-2024 01:53 AM | |||
02-24-2025 11:37 PM | |||
Anonymous
| 07-25-2024 12:14 AM | ||
07-01-2019 10:25 AM |
User | Count |
---|---|
87 | |
81 | |
53 | |
38 | |
35 |