I am not sure how you want to handle M to Date on line chart.
Because the latest month does not have full month, it is not showing trend correctly.
How do you want to handle this?
Line chart is always showing Full month and all others are start(month/year) to date?
I cannot find easy answer on this with considering the combination of whole logic and function limitations.
2 of 2 people found this helpful
Anyways, up to now.
Share Date filter across whole sheet with linking "Date" field on both data source.
Change the date filter to context to capture the latest date with LOD correctly.
==> This does not allow to draw the correct Line chart for the latest month.