Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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.
Did I answer your question? Mark my post as a solution! Proud to be a Super User!
Connect with me!
Stay up to date on
Read my blogs on
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
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |