Connect the Gaps

[angel51496]

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.

[v-sdhruv]

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

[v-sdhruv]

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 You

[v-sdhruv · Accepted solution]

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 Community

Hope this helps!

[Greg_Deckler]

@angel51496 It's asking me to sign in.

[angel51496]

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

[Greg_Deckler]

No, it is asking me to sign in to like your Azure AD (Entra ID) domain. Custom login screen with logos and stuff. 

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[angel51496]

PBIHelp.pbix

My apologies for the delay @Ashish_Mathur! It didn't notify me that you replied! Appreciate any and all help 🙂

[Ashish_Mathur]

That takes me to a sign-in page.

[angel51496]

@Ashish_Mathur I had to upload it onto onedrive to put a link here. Can you not access that? Otherwise how would I share the file?

[Ashish_Mathur]

I cannot access that link.

[Greg_Deckler]

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

[angel51496]

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