DirectQuery Connections to Datasets and Correct Visuals

Hi everyone,

I'm trying to create a report as a summary page of many other reports that all have the same areas of data for different projects. I can connect to all the sepatate datasets for each project using DirectQuery but now I'm realizing there's issues when creating visuals. For example, I want to put budget data from all the different projects onto one clustered column visual. Because the same budget data for each project exists in different fields, it's not displaying correctly. 

Does anyone have any advice for this? Is there a way to make a query that appends the adjacent data from each project into one?