Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Dynamic Column calculation based on Slicer Selection

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

1 Reply

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support

    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