The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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:
Solved! Go to 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
79 | |
71 | |
48 | |
41 |
User | Count |
---|---|
138 | |
108 | |
71 | |
64 | |
58 |