Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

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?  
Capture.PNG




 
 
1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

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


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
Greg_Deckler
Super User
Super User

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


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

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

Thank you both for your Help!

amitchandak
Super User
Super User

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.