Forum Discussion
How to hide Constant y-axis value when the value is blank
I have a line chart with some constant Y-axis values. I filter the line chart to different categories and everything updates appropriately.
However not every category has a value tied to it, some are blank. In these situations, the constant line is showing at the 0% mark rather than being blank. Is there anyway to just hide it instead? or make it transparent?
75th = SELECTEDVALUE(tbl[National75th])
maybe you can try to create a measure
if (xxx=0, blank(), xxx)
then it will skip the 0 value.
1 Reply
ryan_mayuSuper User
maybe you can try to create a measure
if (xxx=0, blank(), xxx)
then it will skip the 0 value.