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
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.