Show comma separated values in card visual.

[SanketBhagwat]

I want to slice my data and produce the output in the card visual as comma separated values.

I have 3 columns, 'groups,divisions and functions' and I have a slicer which has groups field.

I want my output like when I click on groups in my slicer, the visual should show the sliced data in the same visual but as comma separated values.

I have attached screenshot of my data.

If anyone can help, then do let me know.

Regards,

Sanket Bhagwat 

[SanketBhagwat · Accepted solution]

I have solved the above question.

Steps which I followed are listed below;

1)Create a new table using formula,

Test = SUMMARIZE(Sheet,Sheet[Groups],"Names",CONCATENATEX(Sheet,Sheet[Divisions ],","))

2)Select a slicer and add 'Groups' field into it.

3)Drag a card visual and include 'Names' field into it.

I have attached screenshot of the output.

If this post helps, then please mark the same as 'Accept as Solution'.

Regards,

Sanket Bhagwat