Forum Discussion
Dynamic constant line
Hello, I have a graph with 2 curves: - A constant dynamic line - A running total Base on a time line I would like to have a constant dynamic line that adapts automatically to the "timeline"...
Anonymous Assuming that you have a measure for your other line, you could do this:
Constant Line Measure =
VAR __Constant = <constant value goes here>
RETURN
IF(ISBLANK([Other Measure]),BLANK(),__Constant)
Anonymous Assuming that you have a measure for your other line, you could do this:
Constant Line Measure =
VAR __Constant = <constant value goes here>
RETURN
IF(ISBLANK([Other Measure]),BLANK(),__Constant)
Brilliant, I Don't know why I did Not fthought about that one.
Thank you both for your Help!