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.

     

OktayPamuk80's avatar
OktayPamuk80
Icon for Responsive Resident rankResponsive Resident
1 year ago

Hi,

In the Power Query windows, where you prepare the data, you can split the column:

 

And in the settings spit it into rows:

 

For each comma separated value, it generate a record:

Regards,

Oktay

 

If it helped you, would appreciate a KUDOS and mark my answer as a solution 😉