How can I visualize the SELECT_MULTIPLE in power bi?

[buhayha]

Hello,

I have a power bi report that has a slicer per district, so I need everything to be connected to one another.

I want to visualize the multiple select questions from my kobo data as a bar chart in the report.

When I put the answers under the values field, they format like the following:

I am trying to have something similar to this

Thank you very much

[Kal_Lam]

So you mean the label should be next to the bar?

[buhayha]

Yes. Something like what is shown in kobo reports.

[buhayha]

I solved this by creating a separate pivot table for all the multi_select questions

[Kal_Lam]

@buhayha,

[wstanikzai]

This is one way to use a pivot table, but the problem is that it results in a loss of connectivity when filtering the entire dashboard data in Power BI. I’m looking for a solution that allows us to maintain connectivity while using a bar chart @Kal_Lam @buhayha

[osmanburcu]

Hi @wstanikzai,

you can simply duplicated the table and delete the columns that did not need to be in the graph, after that you can unpivot the columns. I am using it frequently for the select multiple questions. If you keep a primary code in the second table (e.x beneficiary ID), then you can connect the tables by relationship so you can keep the connectivity easily.

You can find an example video here: https://youtu.be/QtQIJLMccY8
Inital:

Final

Result:

[wstanikzai]

@osmanburcu
Thank you so much for the solution that you provided. much appreciate