Dynamic column based on slicer selection

Question

Hi&nbsp;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&nbsp;Please help me to create a dynamic column that changes based on slicer selction.Thanks,Mahesh R

jihwan_kim · Answer

Hi,&nbsp;Anonymous&nbsp;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.&nbsp;&nbsp;I created a new table in two steps.&nbsp;New Table = CROSSJOIN (VALUES ( 'Blinded Names'[Name] ),VALUES ( 'Blinded Names'[Blinded Name] ))&nbsp;&nbsp;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])&nbsp;&nbsp;https://www.dropbox.com/s/5webwf1bje8bnl0/mahi.pbix?dl=0&nbsp;&nbsp;&nbsp;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

jihwan_kim · Answer

Hi,&nbsp;Anonymous&nbsp;I am not sure whether I understood your question correctly, but please check the below picture and the sample pbix file.I hid the very first column on the left side of the table visualization (red color area), and tried to only show the Outcome Column on the visualization.&nbsp;&nbsp;Output = VAR selectedname =ALLSELECTED ( 'Company Names'[Name] )RETURNIF (HASONEVALUE ( 'Company Names'[Name] ),IF (SELECTEDVALUE ( 'Blinded Names'[Name] ) IN selectedname,SELECTEDVALUE ( 'Blinded Names'[Name] ),SELECTEDVALUE ( 'Blinded Names'[Blinded Name] )),SELECTEDVALUE ( 'Blinded Names'[Blinded Name] ))&nbsp;https://www.dropbox.com/s/5webwf1bje8bnl0/mahi.pbix?dl=0&nbsp;&nbsp;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

v-luwang-msft · Answer

Hi&nbsp;Anonymous&nbsp;,
You could use the following measure:
Output =
VAR test1 =
    CONCATENATEX ( VALUES ( 'Slicer'[name] ), [Name], "," )
VAR test3 =
    MAX ( 'Table'[Name] )
VAR test2 =
    SEARCH ( test3, test1,, 0 )
VAR test4 =
    IF ( test2 &gt; 0, MAX ( 'Table'[Name] ), MAX ( 'Table'[Blinden Name] ) )
RETURN
    test4
&nbsp;
Final get the below:
If you choose one value:

&nbsp;
If you choose&nbsp;multiple&nbsp; values:

You could download my pbix file if you need!
&nbsp;
Best Regards
Lucien

anonymous · Answer

Hi&nbsp;Jihwan_Kim&nbsp;The Output is coming as expectd only but the issue is I need a column with this similar functionality.So that i can use that conditional colum in the column of the stacket chart.ThanksMahesh R

anonymous · Answer

Hi&nbsp;v-luwang-msft&nbsp;You created a measure to get the expected output where i need the same funtionality in Column.So that i can use this in column of stacked chart.Thanks&nbsp;Mahesh R

Forum Discussion

Dynamic column based on slicer selection

Related content

Variance column for Dynamically selected columns

Dynamic Column Selection in a Table Visual

Dynamic Column headers

Dynamic Column Name

Dynamic Column visibility in table visual based on filter selection