Forum Discussion

e175429's avatar
e175429
Icon for Helper IV rankHelper IV
1 year ago
Solved

Tracking Totals by Dates

Hey all,   This is a sample of my data. The actualy data has over 15k records and I would love to upload the whole thing here to make it easier but I don't know how.   I am trying to track the pr...
  • techies's avatar
    techies
    1 year ago

    Hi e175429 not able to upload file, there is active relationship between prepared date and date, 

    inactive between approved date and date right?

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
1 year ago

Hi,

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

 

 

 

 

  • e175429's avatar
    e175429
    Icon for Helper IV rankHelper IV
    1 year ago

    Thank you for your assistance.

     

    I came very close with your advice, but there is a slight issue.

     

    This is my graph after mirroring your BI file:

    The part that's circled should be merged in between the dates instead of it's own standalone number. Does that make sense?

     

    For instance, here are the empty approved dates in my full data:

    So for March 2024, the line graph for total approved should dip a little below the total prepared by 1.

    For May 2025, the line graph for total approved should dip a little below the total prepared by 13.

    For Aug 2024, the line graph for total approved should dip a little below the total prepared by 22.

    So on....

     

    Both lines, total approved and total prepared, should not be in perfect unison and that "blank" on the x-axis should not be there.