Forum Discussion
How to display comma separated column value in diff rows in table visual ?
Hi pratikrami ,
Sure there is another way. This is the joy of Power BI and data modeling. You can to following:
- On the table (right side), duplicate the table and take only the ID and sites columns.
- Split by columns
- In the first table, you can delete the sites column as this is expanded already in the second table
- Once the data is refreshed you can connect the two tables using ID field
You now have 2 tables, one including ID, Emp_Name and other attributes and a second with just ID and site (expanded.
Hi OktayPamuk80 ,
Thanks for quick reposnse. So this is the only way ..right ? Because I have other columns also in main table I wanted to avoid these expansion of rows. Is there any way using measure or anything, directly without increasing the rows and we can use the same comma seperated text field in table visual ?
Hi pratikrami ,
Sure there is another way. This is the joy of Power BI and data modeling. You can to following:
- On the table (right side), duplicate the table and take only the ID and sites columns.
- Split by columns
- In the first table, you can delete the sites column as this is expanded already in the second table
- Once the data is refreshed you can connect the two tables using ID field
You now have 2 tables, one including ID, Emp_Name and other attributes and a second with just ID and site (expanded.