How i can create a table with multiple value in single data cell on PowerBI ?

[Jackyong1988]

[MFelix]

Hi @Jackyong1988 ,

To achieve this you can use the CONCATANEX syntax that allows you to have multiple values from the same table or use the & syntax to concatenate text strings (can be measures).

[Jackyong1988]

Hi @MFelix 

Thanks for your prompt response.

The CONCATANEX syntax looks like no able to help, i need to put details item in the "Values". e.g. you can see the Month columns, all the 12 months have all the details ball, each ball contain one information and with status legend, and it work in Tableau if i put the item in details, but in Power BI, i no have that option to split the values for details.

Tableau

Power BI

[MFelix]

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.