Forum Discussion

pratikrami's avatar
pratikrami
Regular Visitor
1 year ago
Solved

How to display comma separated column value in diff rows in table visual ?

I have below table structure. I nmy dashboard I have added slicer for EMP_NAME. on selection of any EMP, I neeed to display SITES related to it in table visual. how can I display each site in diff ro...
Need Help
  • OktayPamuk80's avatar
    OktayPamuk80
    1 year ago

    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.

     

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
1 year ago

Hi pratikrami  -Please follow the steps at power query editor.

Select the SITES column.
On the ribbon, choose Split Column > By Delimiter.
In the dialog:
Choose Comma ( , ) as delimiter.
Select Split into Rows (not columns).

 

 

output:

 

file FYR attached