Dynamic column

[punnas1]

Hi, I have multiple Text columns in multiple tables. I want to create table with some of column header names, when I select any text in slicer those text column to be shown in the matrix table.

[v-diye-msft]

Hi @punnas1 

You might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive or dropbox and share the link to the file. Please do not forget to describe the expected results based on this sample data.

[punnas1]

Hi @v-diye-msft 

I'd upload pbix file in following link.

Pls help, Thank in advance.

https://drive.google.com/open?id=14459Ykmh3B2LSEjiKaRkZ1906PZhei5f

[v-diye-msft · Accepted solution]

Hi @punnas1 

1. Please unpivot the Product and Category columns:

= Table.UnpivotOtherColumns(#"Removed Bottom Rows", {"Amount"}, "Attribute", "Value")

 

2. Manage the relationship between them:

3. Final results:

Pbix attached.

[punnas1]

Hi @v-diye-msft ,

If we have data in one table we can unpivot columns, but columns in multiple tables how to unpivot the data.?

is it possible to create measure like this ( measure =

                                                        if (selected values = "product", Table [Product],

                                                        if (selected value = "Category", Table [Category])))

Thanks in advance.

[v-diye-msft]

Hi @punnas1 

I have a sample could be your reference, please see attached.

[punnas1]

dear v-diye-msft,

Can we swith dimention columns based on slicer seletion.

My requirement has mention in File.

thea 

[Greg_Deckler]

Not sure you can get what you want. But can't be sure, Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490