Forum Discussion
How to create display column for multi-select choice?
Hi Anonymous ,
Please follow the below steps to get it, you can open the attachment to check how it works...
1. Select the table and right click "New measure" just as below screenshot
2. Write the below formula in the formula bar
FieldName_Display(Multi) = CONCATENATEX ( FILTER ( 'Table', 'Table'[fieldname] IN ALLSELECTED ( 'Table'[fieldname] ) ), 'Table'[fieldname_display], "," )3. Apply the above measure onto the table visual
Best Regards
Hi Anonymous ,
You can create a measure as below to get it, please find the details in the attachment.
FieldName_Display(Multi) =
CONCATENATEX (
FILTER ( 'Table', 'Table'[fieldname] IN ALLSELECTED ( 'Table'[fieldname] ) ),
'Table'[fieldname_display],
","
)
Best Regards
Hi Anonymous , thanks for this solution. However my data table does not have the _display column to begin with, do you know how to create this multi choice _display column in the table?
Hi Anonymous ,
Please follow the below steps to get it, you can open the attachment to check how it works...
1. Select the table and right click "New measure" just as below screenshot
2. Write the below formula in the formula bar
FieldName_Display(Multi) = CONCATENATEX ( FILTER ( 'Table', 'Table'[fieldname] IN ALLSELECTED ( 'Table'[fieldname] ) ), 'Table'[fieldname_display], "," )3. Apply the above measure onto the table visual
Best Regards
Hi Anonymous when we import the data columns from CDS to Power BI, it does not import the _display column. How do we create it?