Forum Discussion
Visualize multi select kobo data
I have data from kobo that looks in a format like this
| S | M | L | |
| Blue Shirt | 1 | 0 | 1 |
| Blue Shirt | 1 | 1 | 0 |
| Red Shirt | 1 | 1 | 0 |
| Yellow Shirt | 0 | 0 | 0 |
I am trying to make my export look like the following
While having the first column as a slicer.
1 Reply
Anonymous it is a best practice to use unpivoted data, so in your case, you need to unpivot it:
Transform Data -> Select First Column that has shirt value -> Right Click -> Unpivot other columns
You will get attribute and value columns, rename them as you see fit. Close and apply
Use clustered bar chart visual, put attribute column on the axis, value column on values and that will do it.
✨ Follow us on LinkedIn and to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.
