Don't show null value on reference line on line chart

[ChemEnger]

I have a line chart, with temperature data against date.  The various temperatures that I am measuring (selected by slicer against an unpivoted dataset) always have an upper limit but not always a lower limit.  For the data with no limit, the reference line is showing as zero - is there a way (other than a calculated column) to not show the line if blank?

The limit data is in a second table (CQA = Critical Quality Attirbute) connected to the unpivot by tag number = Instrument ID.  I have tried adding an IF... BLANK() calculated column to the CQA table, to no avail.

CQA Table with max & min CQA, and calculated LSL column:

LSL = IF([Min CQA]>0,[Min CQA],BLANK())

Relationship between Unpivot & CQA:

Example with both Max & Min limits:

Example with (incorrect) 0.0 lower limit (this is the same whether I use Min CQA or the calculated LSL:

[Anonymous]

Hi, @ChemEnger 

Thanks for amitchandak's reply. Open the link but no files. Could you please check to see if the file. Feel free to help.

Here are some notes:
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Best Regards,
Yang
Community Support Team

[ChemEnger]

Thanks for the quick reply @amitchandak,

Just tried that and got the same outcome 🙁  I have tried:

LSL = Min(CQA[Min CQA])

LSL = IF(Min(CQA[Min CQA])>0,Min(CQA[Min CQA]),BLANK())

LSL = IF(NOT(ISBLANK(Min(CQA[Min CQA]))),Min(CQA[Min CQA]),BLANK())

(I was using the 'Min of' [Min CQA] here before)

All still show the 0.0 line on the chart.  @Anonymous thanks for the reply.  The expected output is no lower reference line on the chart, as the Min CQA doesn't exist for some data, as per my original post.  This is what I would expect to see:

Cleansed version of the file saved on OneDrive Dropbox - Null LSL (Edit: Dropbox rather than OneDrive, although I could still see the file!)

[amitchandak]

@ChemEnger , Based on what I got you should use a measure in constant line using Fx option

a measure like below

m1 = Min(Table[LSL])

use in constant line

[jan_steger]

@amitchandak thanks for the suggestion, but this is not working:

As well with a MIN-function in the Measure it is plotting a line at 0.