What you are describing sound like a union of two datasets. Union datasets is currently not supported natively within QuickSight unless the same datasource is used and custom SQL would be an option, like for Amazon Athena, PostgreSQL, etc.
At AWS, our roadmap is primarily driven by our customers. Your feedback helps us build a better service. I have noted this in our internal feature request tracker.
To stay up-to-date with the latest QuickSight updates, please have a look at and subscribe (“watch”) to the What’s New/Blog category .