dropdown list in a row

[JacekStolarski]

I connected power bi to sharepoint list with multiplay choses. I AM looking for three jest way to make a chart off this. I tried to divaide into rows but its mess up other statistics for example count of rows which is immportant. Plz help

[ImkeF · Accepted solution]

Hi @JacekStolarski ,

I'd recommend to reference that query and create a new table where you expand that column to new rows. Make sure to keep the key column in that table to connect that table with your original table in the data model.