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
v-luwang-msft's avatar
v-luwang-msft
Community Support
5 years ago

Hi Anonymous ,

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 > 0, MAX ( 'Table'[Name] ), MAX ( 'Table'[Blinden Name] ) )
RETURN
    test4

 

Final get the below:

If you choose one value:

 

If you choose multiple  values:

You could download my pbix file if you need!

 

Best Regards

Lucien

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi v-luwang-msft 

    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 
    Mahesh R