Forum Discussion
Defining high and low limit on line chart
Hi all,
This is basically what I want to recreate in Power BI.
I am not able to figure out how to set the high_limit and the low_limit, which I have as 2 different columns in the table. The measurement is also a separate field in the table.
Thank you for you help.
Hi. You can enrich your line chart with the Analytics Pane. You can read more about it here: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane
The pane will let you draw different things over the line chart. One of those settings it's Y-Axis Constant Line. You can add those constant lines with delimtied hardcode value or using a Measure that would be like a function with a calculation to adapt depending your needs or filters.
If you already have the column for the line, you could create a measure like average or sum of the column depending the axis and how the data is loaded.
I hope that helps,
1 Reply
- ibarrau
Super User
Hi. You can enrich your line chart with the Analytics Pane. You can read more about it here: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane
The pane will let you draw different things over the line chart. One of those settings it's Y-Axis Constant Line. You can add those constant lines with delimtied hardcode value or using a Measure that would be like a function with a calculation to adapt depending your needs or filters.
If you already have the column for the line, you could create a measure like average or sum of the column depending the axis and how the data is loaded.
I hope that helps,