Constant line parallel to the x-axis but variable depending on the filter

[Syndicate_Admin]

I have a dashboard in Power BI that aims to see quality parameters of a product that we have based on tolerance limits assigned by different packaging. I am doing this by means of two tables, one is the quality database where (among others) they have columns of the packaging code and in others they have the types of defects that exist for this product, and each row is a correlative of each product reviewed where the packaging code of the revised product and the number of defects that appear in each one are imputed. The other table I created just to relate those packaging codes with their tolerance limits, in which 5 different categories enter and I relate each code with the tolerance that corresponds to it, those tolerances are separated into several columns (quantity determined according to the category of the packaging). Once I did this, I combined queries so that my main table is assigned to the different inputs the tolerances that correspond based on their packaging codes and graphed this data in a graph of grouped lines and columns, however, and this is where I present difficulties. When I want to analyze a single input my tolerances can't be seen as a continuous line parallel to the X-axis, but as a single point (image attached)

the points are the tolerances that each package has, the columns are the amount of "x" defect present in the product (all in percentage) and the X axis is the number of the correlative process where the sampling was carried out (they could well be dates as well). The thing is, since the tolerances are variable depending on the packaging code, I can't do it in a column chart and insert a constant line since I need these tolerances to move based on this same packaging code. The only way for these to present themselves as a solid line is when I observe several points on the X-axis, however in order to see a process in detail it would be useful to see them at all times. Attached is an image of the complete panel so that you can see the filters as well.

For my part, it occurred to me to separate it into several graphs and with the help of measurements that only the data corresponding to one type of packaging is graphed (the same for all types) and use a column graph in order to be able to draw the constant line, however, I would prefer to keep everything in a single graph. Thank you in advance for your help, I look forward to your comments.

[amitchandak · Accepted solution]

@Syndicate_Admin , Based on what I got so far, In Constant Line you can use Measure using fx.

The measure can be created based on the selected value.

example

Dynamic Tolerance Limit =
VAR _pkg = SELECTEDVALUE('PackagingTable'[Packaging Code])
RETURN
CALCULATE(
MAX('ToleranceTable'[Tolerance Limit]),
'ToleranceTable'[Packaging Code] = _pkg
)

[Syndicate_Admin]

Thank you so much for your outreach and help, it turned out perfectly.