power kpi matrix

Thanks for this great visual, it works pretty well for me.

Only one thing is a bit annoying. It always shows the data for the last value of the selected date field. In the Actual and Comparison values I would like to show an average for the selected dates (which is exactly what my underlying measure calculates), but this is not working now because it now only takes the "average" for the last date.

Could you consider adding the option to show the "total" for the selected date fields instead of only the last one?

Or provide an option to use a different field in the spark line than the one in Date, that would be even better perhaps.