There currently is not dynamic formatting like that within Tableau (although you are certainly not the first with this request--it would be a good one to place in the Ideas section of the Community!). One workaround I came up with was creating a calculated field (0) and making it a dual axis with the other measure. Then, change the mark type to be text. I've attached a screenshot. Hope this helps!