Defining high and low limit on line chart

[samurai_jack]

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.

[ibarrau · Accepted solution]

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,