Forum Discussion
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 created from the data source. For example,
| fieldname | fieldname_display |
| 0 | A |
| 1 | B |
| 2 | C |
| 3 | D |
| 4 | E |
How can it be created for multi-select choices?
Such as,
| fieldname(multi) | fieldname(multi)_display |
| 0,1 | A,B |
| 1,2,3 | B,C,D |
| 3,4 | D,E |
| 0 | A,B |
| 2,3 | C,D |
It will only display the left column, to show the choice IDs selected, with a comma to separate the values. How can it be done but to show the values of the choice IDs?
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
4 Replies
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