title: Waterfall Chart - Power Bi
body: <p>I have this measures</p>
  <ul>
  <li>Merma_Total = sum(FullDataSet[Imp_MermaTotal])</li>
  <li>Merma_Sobrante = sum(FullDataSet[Imp_MermaSobrante])</li>
  <li>Merma_Faltante= sum(FullDataSet[Imp_MermaFaltante])</li>
  </ul>
  <p>The result of them is</p>
  <ul>
  <li>Merma Total = 2,479,491</li>
  <li>Merma Sobrante = 6,485,129</li>
  <li>Merma Faltante = -4,005,638</li>
  </ul>
  <p>and I'm trying to achieve something like this
  <a href="https://i.stack.imgur.com/Vm9Q9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Vm9Q9.png" alt="enter image description here" /></a></p>
  <p>Tried a variation measure like some tutorials I read and put it into values but don't seem to work, any idea how to achieve this? I'm gonna put the measure down here just to prove you guys I tried something and I'm sorry if it doesn't makes sense but I'm a beginner on Power BI, thanks for the help!</p>
  <pre><code> Variacion Mermas =  
  VAR SelectCategoria = SELECTEDVALUE(Categoria[Categoria]) 
  VAR SelectEscalera = SELECTEDVALUE(Merma[Merma])
      
  RETURN 
      SWITCH (selectedCateogoria, 
         &quot;Mermas&quot;      
            SWITCH(selectedMermas,  
            &quot;Merma Sobrante&quot;, -1*[Merma Sobrante],     
            &quot;Merma Faltante&quot;, -1*[Merma Faltante],     
             [Merma Total]), ` 
  
     &quot;Merma Total&quot;,    
        SWITCH(SelectEscalera, 
        &quot;Merma Sobrante&quot;,0,&quot;
         Merma Faltante&quot;,0,
        [Merma_Total]))
  </code></pre>