title: Power BI Between two Values
body: <p>I've got a problem in PowerBI which im trying to solve for quite a while now.
  I made a histogram which shows me how often a value exists.
  For the values I have a upper and lower limit.
  Also I want to have a vertical targetline which shows me where the values should be.
  There's also a slicer where I can select different stations and depending on that the values, limits and targetgoal change.</p>
  <p><img src="https://i.stack.imgur.com/YOBoI.png" alt="Histogram" /></p>
  <p>The problem is that the targetline doesn't always appear. Always then when there is no value at the exact spot where the targetline should be.</p>
  <p><img src="https://i.stack.imgur.com/LZahY.png" alt="Target Line not showing" /></p>
  <p>In this Picture the target line should be at 61. but there is no &quot;Wert&quot;.</p>
  <p>I really tried a lot of things to get it working but it just do not want to work. It only works if I set &quot;show all values&quot; on the shared axis. But I only want to see All_Values within the limits.</p>
  <p>The DAX for the target line is: <code>targetline = IF(ISFILTERED(Stationen[Station]), IF( VALUES('Values'[All_Values]) =[Target],300,0),BLANK())</code></p>
  <p>So I hope there is a possibilitiy to only show &quot;All_Values&quot; in between the limits. I tried to write a measure but there are no measures allowed as shared axis.</p>
  <pre><code>Values_Between = CALCULATE(VALUES('Values'[All_Values]),Filter('Values'[All_Values]&gt;[LL] &amp;&amp; 'Values'[All_Values]&lt;UL))
  </code></pre>
  <p>Because when I only show <code>All_Values</code> between the Limits, I can turn on &quot;show values whith no data&quot;</p>
  <p>I would really appreciate if someone could help me. It can also be a completely different approach.</p>