Forum Discussion

nkpenta's avatar
nkpenta
Microsoft 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?
  • nkpenta's avatar
    3 years ago

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