Forum Discussion
Evaluate a string as a column name
Hi, I'm new to Power BI and I'm having some troubles trying to evaluate a string as a column name. I have a table like BIG TABLE Field1, Field2, ..., Field30 0.3, 0.4, ..., 0.2 0.5, 0.2, .....
SteveCampbell
Memorable Member
Memorable MemberHello,
Is there a key to this table? I'm assumin you will need another filter to see what row you are reffering too?
One way is you can unpivot your table.
Go to advanced editor. If you have a key, select that column, If not add an index in Add Coulmn > Index Column. Select this new column.
Click Transform tab. On the "Unpivot Columns" dropdown, Click "Unpivot Other Columns". It will now give you Attribute and Value column. Attribute is your column name (FIELD X), which you can use in your slicer.