Forum Discussion
Dynamic column based on slicer selection
Hi I have a list of company names and their blinded company names as below. If i put the name in slicer and selected a value(let it be "ABC"). The output in the column should be ...
Hi, Anonymous
Thank you for your feedback.
At this moment, the only way that I can think of is to create a new table like below.
Please check the below picture and the sample pbix file's link down below.
I created a new table in two steps.
New Table =
CROSSJOIN (
VALUES ( 'Blinded Names'[Name] ),
VALUES ( 'Blinded Names'[Blinded Name] )
)
New Column =
IF (
LOOKUPVALUE (
'Blinded Names'[Blinded Name],
'Blinded Names'[Name], 'New Table'[Name]
) = 'New Table'[Blinded Name],
'New Table'[Name],
'New Table'[Blinded Name]
)
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
HI Jihwan_Kim
Full join for a table with 6Crore reocrds may cause a issue will try it once .
Thanks
Mahesh R