Chart formatting to Hide 0

Hi,

On my Charts, to hide numbers that are 0, I use this formatting #"". This works without any issue.

I also have another requirement where I want to display currency data in Millions. I use this formatting #,##0.00,, "M" which also works.

How do I incorporate both? I want the Millions display, and when the data value is 0, I want to hide that aswell. Can someone help?

Sample uploaded.

Thank You,
Deep

This worked

[>=1000000]#.#0,,"M";[>=1000]#.#0,,"K";;