title: How do we add custom rows using in power bi based on specific string in a column
body: <p>Need suggestions how do we create rows to existing table which is pulled in Power BI through direct query. For instance I have Emp Table with a Column which contains coma separated activities by Students like Reporting,Analysing,Troubleshooting (These are just . I am trying to create a measure to add rows for each activity so that I can display activity matric in Pie Chart.</p>