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

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
some_analyst
Helper I
Helper I

Line graph showing dates up to certain date for one metric

I have two metrics and the graph looks like that:

 

Completion Expected = 
 
CALCULATE (
    COUNTROWS ( VALUES ( StaticBacklog[ID_Number_Desc] ) ),
    FILTER ( ALL ( 'Date_DIM' ), Date_DIM[Date] >= MAX (Date_DIM[Date]) || ISBLANK(Date_DIM[Date]))
)

 

Completion Actual = 
CALCULATE (
    COUNTROWS ( VALUES ( StaticBacklog[ID_Number_Desc] ) ),
    FILTER (
        ALL ( 'Date_DIM' ),
        Date_DIM[Date] >= MAX ( Date_DIM[Date]) || ISBLANK ( Date_DIM[Date] )
    ),
    USERELATIONSHIP ( Date_DIM[Date], StaticBacklog[Decision Made Date] )

)

 

some_analyst_0-1742848637197.png

 

How do i make the brownish line only lead up to today  and the other line goes further into the future?

1 ACCEPTED SOLUTION
Deku
Super User
Super User

Completion Actual = 

Var result =
CALCULATE (
COUNTROWS ( VALUES ( StaticBacklog[ID_Number_Desc] ) ),
FILTER (
ALL ( 'Date_DIM' ),
Date_DIM[Date] >= MAX ( Date_DIM[Date]) || ISBLANK ( Date_DIM[Date] )
),
USERELATIONSHIP ( Date_DIM[Date], StaticBacklog[Decision Made Date] )

)

Return

If( max( Date_DIM[Date] ) < today(), result)


Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

View solution in original post

1 REPLY 1
Deku
Super User
Super User

Completion Actual = 

Var result =
CALCULATE (
COUNTROWS ( VALUES ( StaticBacklog[ID_Number_Desc] ) ),
FILTER (
ALL ( 'Date_DIM' ),
Date_DIM[Date] >= MAX ( Date_DIM[Date]) || ISBLANK ( Date_DIM[Date] )
),
USERELATIONSHIP ( Date_DIM[Date], StaticBacklog[Decision Made Date] )

)

Return

If( max( Date_DIM[Date] ) < today(), result)


Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

Helpful resources

Announcements
October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.