Forum Discussion
Combine Two Visual Tables
The datapoints are columns. Table 1 and Table 2 are constructed by using the table visual. Nothing fancy, each column from its respective table is dropped in. The problem is that Data 2 and Data 5 are columns from two entirely different tables, but the way the complex relationships work, pull the same data.
The data I'm using is sensitive so I unfortunately can't post specific examples, which I know is a pain when trying to figure the problem out.
If you are pulling actual fields from tables to construct each visual, you could create mockup tables in Excel with the column structures for each table used. As an alternative, create a dummy PBIX without any values, filtering down rows and replacing names, all dowable in Power Query.
But up to you.