title: Read value from a different table for Y-axis constant line in Power BI
body: <p>I have a scatter chart and a db view to get the necessary data from it. This view only returns the names and its's respective values and is enough to make my chart just fine. Problem is that i want to draw a <strong>Constant Line</strong> on my chart but i want to read its value from a configuration table that i have in my DB. Currently when i try to add the <strong>Y-axis constant line</strong> in <code>power bi</code>, it only allows me to type the static value and it won't get the data dynamically from somewhere else; a different key-value based table that i already mentioned above. How can i achieve this?</p>
  
  <p>Here's the images:</p>
  
  <p><img src="https://imgurl.ir/uploads/l6094_.png" alt="Power Bi Constant line"></p>
  
  <p><img src="https://imgurl.ir/uploads/m720819_.png" alt="Key-Value base Db tabel"></p>
  
  <p>Thanks in advance.</p>