Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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  ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Jihwan_Kim 

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.

Thanks
Mahesh R

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    HI Jihwan_Kim 

    Full join for a table with 6Crore reocrds may cause a issue will try it once .


    Thanks 
    Mahesh R