Forum Discussion

Jackyong1988's avatar
Jackyong1988
Regular Visitor
4 years ago

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

 

Need Help

3 Replies

  • MFelix's avatar
    MFelix
    Super User
    4 years ago

    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's avatar
      Jackyong1988
      Regular Visitor
      4 years ago

      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's avatar
        MFelix
        Super User
        4 years ago

        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.