Dynamic constant line

[Anonymous]

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?  

[Greg_Deckler · Accepted solution]

@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]

Brilliant, I Don't know why I did Not fthought about that one. 

Thank you both for your Help!

[amitchandak]

@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.