Forum Discussion
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 entered, to be a plateau until the new value. Any advice would be great! These values are based on sourcekeys and obviously the latest adjustment on the value for that date.
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!
13 Replies
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
Hi,
Share the download link of the PBI file.
PBIHelp.pbix
My apologies for the delay Ashish_Mathur! It didn't notify me that you replied! Appreciate any and all help 🙂That takes me to a sign-in page.
angel51496 It's asking me to sign in.
Greg_Deckler I had to upload it onto onedrive to put a link here. Can you not access that? Otherwise how would I share the file?
No, it is asking me to sign in to like your Azure AD (Entra ID) domain. Custom login screen with logos and stuff.
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!
Hi angel51496 ,
Just wanted to check if you got a chance to review the suggestions provided and whether that helped you resolve your query?
Thank YouHi angel51496 ,
Since we didnt hear back, we would be closing this thread.
If you need any assistance, feel free to reach out by creating a new post.
Thank you for using Microsoft Community Forum
