Dynamic Table based on Parameter Selection

[satishkoneri]

Hi Super Users,

Please can you advise if this is acheivable.

I have a table with some dimentions and values as below (lets call it as MainTable):

MainTable
CustID	PartID	SalesType	Location	Value
CustA	Part1	TypeA	Loc1	34
CustB	Part1	TypeA	Loc2	4
CustC	Part2	TypeA	Loc2	34
CustD	Part2	TypeA	Loc3	23

I will manually create another table with just one column with values as column headers from MainTable as below (lets call it as ParameterTable):

ParameterTable

ColumnHeaders

CustID

PartID

SalesType

Location

I will create a single select slicer for ColumnHeaders in ParameterTable.

I would like to create a dynamic table by referencing column name selected through slicer and get unique values matching the column name from MainTable. (example below if I select PartID)

DynamicTable
SelectedColumn	ColumnValue
PartID	Part1
PartID	Part2

[v-diye-msft · Accepted solution]

Hi @satishkoneri 

Create a new table dynamically is not accessible, but there're workaround probably meet your requirements:

1. I have worked out a similar question. and attached the pbix here.

2. here's other threads could provide more hints:

https://community.powerbi.com/t5/Desktop/Dynamically-choose-columns-based-on-slicer/td-p/438019 

https://community.powerbi.com/t5/Desktop/dynamic-column-selection-based-on-slicer/td-p/397923 

3. You can also try the Matrix visual to be a trick, I attached the pbix here.

[Greg_Deckler]

Tables are calculated during data load and are not interactive like that.