Forum Discussion
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-msftCommunity 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