title: Trying to get 0 as minimum value vertical axis in chart of SSRS
body: <p>I am working on a SSRS report which requires a chart to show vertical axis in 'M' or 'K' like 0, 2M, 4M. I got a custom formatting formula which adds an 'M' or 'K' with numbers - </p>
  
  <pre><code>=Switch(Fields!TotalSpendCurrent.Value &lt; 1000, "0.#", Fields!TotalSpendCurrent.Value &lt; 1000000, "#,.#K", true, "#,,M")
  </code></pre>
  
  <p>But with this I am getting 'M' or 'K' as minimum value not 0.</p>
  
  <p><a href="https://i.stack.imgur.com/icW4v.png" rel="nofollow"><img src="https://i.stack.imgur.com/icW4v.png" alt="enter image description here"></a></p>
  
  <p><strong>Current Output Screen</strong></p>
  
  <p><a href="https://i.stack.imgur.com/Cd68I.png" rel="nofollow"><img src="https://i.stack.imgur.com/Cd68I.png" alt="enter image description here"></a></p>