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 , You can use options in analytics pane or create a measure that returns dynamic fix value and use it
https://docs.microsoft.com/en-us/power-bi/desktop-analytics-pane
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.