Dynamically show missing values in a line graph with max date value of particular fields

Hi Team, Category Date NAV Equity ABC 9/10/2024 250   ABC 9/9/2024 201   ABC 9/6/2024 152   ABC 9/5/2024 103   ABC 9/4/2024 54   ABC 9/3/2024 20   AB...