I have a table like this, it comes from a googleforms and is updated every new answer.
I don't have access to the form so they will keep coming like this.
|John||Monday, Friday, Sunday||Football, Skiing, Cycling||Car, Motorcycle, Bicycle|
|Paul||Tuesday, Friday, Saturday, Sunday||Football, Basketball, Golf||Car, Bicycle|
|Andrew||Saturday, Sunday||Golf, Skiing||Motorcycle|
|Steve||Tuesday, Sunday||Basketball, Cycling||Car, Motorcycle|
I need one graph for each column, showing the amount of answers for each of the items.
- how many people available on each day of the week
- how many people interested in each sport
- how many people own each of the vehicles
While also allowing to know for example who and how many people on sundays can use a car, etc.
I suppose it's simple, but I'm new in powerbi, stuck on that problem, and don't even know how to look for the solution 😂