Can you put a screenshot of what exactly what you are looking for?
You can use two sheet on the dashboard to show it as one which you already must be knowing. Still checking a possibility if I can help you with the thing that you are looking for in a single sheet,
You can create some sample in excel or tableau on superstore for the same.
Thanks and Regards,
I am trying to create 1 report in chart format another one table format but should be single sheet.
Is it possible ?