Forum Discussion

nkpenta's avatar
nkpenta
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago
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?
General Comment
Tips and Tricks
  • nkpenta's avatar
    nkpenta
    3 years ago

    Added if condition on the measure as below to fix the issue. it works now.
    if(measure<>blank(),measure,"Text")

009co's avatar
009co
Icon for Helper IV rankHelper IV
3 years ago

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.

ManuGP's avatar
ManuGP
Icon for Advocate I rankAdvocate I
1 year ago

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