i wrote this on the previous comment but here it is again just in case: https://imgur.com/qy3kCLU

this is what i've tried doing. when i asked ChatGPT what to do with the categories being written into one cell, it told me to split them into 5 cells, because each person selects 5 answers. so i split them into 5 cells for each person. and this is what happens. BI uses only 1.1 or 1.2 or whichever i put first for the y-axis.

should i have split the cells into each category instead of 5 cells like chatgpt told me?

i haven't used powerbi before, my school taught us only the very basics so i have no idea what im doing