Table/Matrix with multiple column

[ashraf_SISL1]

Hi All,

I want to use an matrix or table in PowerBi, where i can add 02 or more columns seprately(as per imange below). I am unable to acheive the same in default PowerBi Table/Matrix.

Is there any way i can achieve the same in default (By scipting) or do i need to import a new Tabel/Matrix from market place.

Regards,

Ashraf 

[ashraf_SISL1 · Accepted solution]

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

[VasTg]

@ashraf_SISL1 

Your question is not quite clear.

Would you like to show column1, column2 and so on? Column1, column2, etc., should be values/elements of an attribute just like plan199,plan299,plan 399, data111 etc are elements of "No of plans sold" attribute. 

To achieve the expected results, your table should look like below and you could use the "Actual Column1 name"

and "Actual Column2 Name" in the column section of matrix.

Actual Column1 Name	Actual Column2 Name
Column1	Plan 199
Column1	Plan 299
Column1	Plan 399
Column2	Data111
Column2	Data299
Column2	Data399

If this helps, mark it as a solution.

Kudos are nice too.

[ashraf_SISL1]

Hi @VasTg ,

I want to use column1, column2 and so on..as per typical client requirment.

Thanks..

[VasTg]

@ashraf_SISL1 

Check out @Icey answer on this post.

https://community.powerbi.com/t5/Desktop/Group-Measures/m-p/855173#M410362

If this helps,mark it as a solution.

Kudos are good too.

[ashraf_SISL1]

@VasTg Unfortunately we cant combined the column, is there any other way or any other table or matrix i can use from marketplace.

[PaulDBrown]

@ ashraf_SISL1

Actually you can, and it’s simple to do. (I’ll post an example when I have access to a pc)
Can you share sample data and data structure?

[ashraf_SISL1 · Accepted solution]

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

[PaulDBrown · Accepted solution]

@ashraf_SISL1 

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