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" of the running total (affected by filter on the page).
At the moment, the constant line is applied to the full time span of the time line ignoring any filter on the page. Does anyone have an idea?
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)
3 Replies
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.
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)
