Forum Discussion
Solved
Connect the Gaps
I have a graph in power bi that I can't get these lines to connect. I have created the date table but the line graph still doesn't connect. Essentially I would like to connect the last value that was...
Hi angel51496 ,
Just wanted to check if you were able to resolve your query?You can refer a similar post here-
Solved: Joining lines in line chart - Microsoft Fabric Community
Solved: Line Chart appears non-continuous - Microsoft Fabric CommunityHope this helps!
angel51496 You can potentially adjust your measure as follows:
New measure =
VAR __Value = [Old Measure]
VAR __Result =
IF(
__Value <> BLANK(),
__Value,
VAR __Year = MAX( 'Dates'[Year] )
VAR __Month = MAX( 'Dates'[Month )
VAR __Day = MAX( 'Dates'[Day] )
VAR __Date =
MAXX(
FILTER(
ADDCOLUMNS(
FILTER( ALL( 'Dates' ), [Year] = __Year && [Month] = __Month && [Day] < __Day )
"__Measure", [Old Measure]
),
[__Measure] <> BLANK()
),
[Date]
)
VAR __Result = MAXX( FILTER( __Table, [Date] = __Date ), [__Measure] )
RETURN
__Result
RETURN
__ResultGreg_Deckler didn't have luck with that. Here is a link to a copy of the report with mock data if that helps!
PBIHelp.pbix
