Table/Matrix with multiple column

PaulDBrown  I want to show my data something like below, where column 1 & column 2 coming from different tables

Anonymous 

OK, but we need to see the structure of the model. In order to be able to create the matrix with columns from different tables you will to create a common table which appends column1 and column2 values. This is what you will be using as your column reference in your matrix. 

To get a better idea of what I'm talking about, here is a simple model:

and you can create a matrix like this:

Therefore, if you need to show columns from different tables (which obviously are different values) you need to create a lookup/Dim table which lists the values from your columns in one single column to use as your column values in the matrix.

Here is an example for you:

To create this, I referenced the data table to a new table, unpivotted the Market and Division columns (therefore creating a single column including both - which incidentally means rows values for "Actuals" and "Forecast" are duplicated, which you need to be aware of), then created a lookup table with this new column etc...

Here is the sample file if you're interested: PBIX File