Forum Discussion
Solved
dynamic constant line for blank value
HI, Dynamic constant line is showing at 0 when the measure value is blank. how can we not show the constant line when the measure value is blank?
Added if condition on the measure as below to fix the issue. it works now.
if(measure<>blank(),measure,"Text")
The Placeholder solution is fantastic. It mitigates this Constant Line null to zero bug.
Just want to highlight that the solution requires putting the Placeholder = 0 constant line first before the other real constant lines.
Exactly! I was finally able to workaround the bugs in my particular scenario with this solution. As there is no option to adjust the order of the ref lines it means you need to DELETE any lines you have, then start with the Placeholder = 0 and THEN add the ref lines you need. Thanks to both Anonymous and 009co