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