Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to create display column for multi-select choice?

Using CDS as data source to create Power BI graphs. In the data tables, there is a display column that can show the value of the choice ID selected for single-select choice columns in each row. It is...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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? 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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?