How can I visually represent the responses to multiple-choice questions in Power BI using existing data, where each column corresponds to a choice, each row represents an entry, and cells contain either 1 or 0 based on whether the user chose or did not choose a particular option? I aim to create the visualization without the need to create a new table.
Welcome to the community, @raneemelnambulsieh! I am pinging @osmanburcu, who should be able to help you with this.
Hi, thank you @Kal_Lam ,
@raneemelnambulsieh if you don’t want to add table, you can unpivot your table with a dax formula mentioned as below:
1 Like
