Dynamic Column calculation based on Slicer Selection

[Anonymous]

I have Below tabels

Table1

Values   CITY        County 

 1            Delhi      IND

 2            Pune      IND

 3            Hyd        IND

City_Table

Pune  Hyd  County

P         A       IND

Q        B       IND

R         C       IND

I have one multi value select slicer on 'Table1'[Values]

If user selects 1 then hardcoded value Delhi should appear as column name and column Value.

If user select 2 then Pune will be Column name and p Q R is column Data. like that

So OutPut will be like this

If 1,2 Selected on Slicer

Delhi   |   Pune

--------------------------------

Delhi       P

Delhi       Q

Delhi       R

[v-lili6-msft]

hi, @Anonymous 

For your requirement, I'm afraid it couldn't achieve in Power BI for now.

Dynamic Column name is not possible for now, and value couldn't match with other columns dynamically

Best Regards,

Lin