cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
carlam Frequent Visitor
Frequent Visitor

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, ..., 0.88

...

 

and a listbox like

FIELDS

FIELD_X

Field1,

Field2, 

...,

Field30

 

I get what I select on the listbox as Selected_X = SELECTEDVALUE(FIELDS[FIELD_X]). So, if I select "Field13" on FIELD_X I get Selected_X ="Field13". 

Now I want a columnX to become dynamically equal to 'BIG TABLE'[Field13].

 

I tried column_X="'BIG TABLE'[" & Selected_X & "]" but it didn't work.

 

How can I get this?

 

Thanks, 

 

Carla

 

3 REPLIES 3
Highlighted
carlam Frequent Visitor
Frequent Visitor

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 big table like

BIG TABLE

Field1, Field2, ..., Field30

0.3, 0.4, ..., 0.2

0.5, 0.2, ..., 0.88

...

and a slider like

FIELDS

FIELD_X

Field1,

Field2, 

...,

Field30

 

I get what I select on the slider as Selected_X = SELECTEDVALUE(FIELDS[FIELD_X]). So, if I select "Field13" on FIELD_X I get Selected_X ="Field13". 

 

Now I want a columnX to become dynamically equal to 'BIG TABLE'[Field13].

 

I tried column_X="'BIG TABLE'[" & Selected_X & "]" but it didn't work.

 

How can I get this?

 

Thanks, 

 

Carla

 

SteveCampbell Established Member
Established Member

Re: Evaluate a string as a column name

Hello,

 

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.

 

 

 

Kripesh Frequent Visitor
Frequent Visitor

Re: Evaluate a string as a column name

Did you ever obtain your solution? I am having same issue. It would be great help if you could post how u approach to get a solution. 

 

Thanks, 

K

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 6 members 2,096 guests
Please welcome our newest community members: