Additional lines in chatter chart

[LNIEL]

Hi, 

I have a chatter charts that I want to add 4 additional lines to (a specific value in 4 different columns)

I work in a hospital. My current Power BI request looks like this: 

- each drug (15 different) is testet against a bug (disease - fx influenza)(21 different) every day.

- The result is a zone measured in Millimeters (MM)

- In my report, the users start out by selecting a drug (drug slicer) and a bug (bug slicer).

- the chatter chart now shows the dates on the x axis and the zones in millimeters on the y-axis. The measurement of each day is not related to the measurement of the previous day. So it needs to be a chatter chart. 

However. For each drug + bug combination, there is a 'Target low' (green line Excel in picture), 'target high' (green line in Excel picture - often the same value as target low), 'tollerance low' (lower red line in Excel picture), 'tollerence high' (upper red line in Excel picture). 

All of these four values are fixed but only for a specific bug + drug combination. 

I see a posibility in the analytics pane to add additional lines but not based on columns. 

Is it in any way possible to add these 4 columns as lines in the chatter chart (like they are in the Excel picture above)?

My solution rigtht now, looks like this: 

(Preferably I would have liked the Y-axis not to make an average of Zone_mm for each day, but as I see it, the only possibility in a chatter chart is to make a calculation on the y-axis. And I only have one measurement per day per bug + drug combination)

I really hope, that someone can help me. 

I am using Power BI RS until we are allowed to use M365 later this year. 

[Ritaf1983 · Accepted solution]

Hi @LNIEL 
You can use Constant lines to achieve this goal ( I think that it work at report server as well, because it is old feature and not in preview).
The value can be hardcoded or you can create a measure and pill it into the constant

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly