Forum Discussion
Mutiple answer question in power BI
Dears, please i need your help where i am not sure how to visualize multiple answers question, where each respondent has more than answer that were entered in a different column, for ex answer ...
lbendlin
Super User
Super UserPlease provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
| ID | F2a.Code1 | F2a.Code2 | F2a.Codes3 |
| 100 | 1 | 1 | |
| 101 | 3 | 3 | |
| 102 | 2 | 2 | |
| 103 | 3 | 3 | |
| 104 | 3 | 3 | |
| 105 | 1 | 1 | |
| 106 | 3 | 3 | |
| 107 | 2 | 2 | |
| 108 | 1 | 1 | |
| 109 | 1 | ||
| 110 | 1 | ||
| 111 | 1 | ||
| 112 | 2 | ||
| 113 | 1 | ||
| 114 | 1 | ||
| 115 | 2 | ||
| 116 | 3 | ||
| 117 | 3 | ||
| 118 | 2 | ||
| 119 | 4 | ||
| 120 | 1 | ||
| 121 | 4 | ||
| 122 | 1 | ||
| 123 | 2 | ||
| 124 | 1 | ||
| 125 | 1 | ||
| 126 | 4 | ||
| 127 | 2 | 1 |