Shaping Multiple-Select Survey Data for Visualization

[KK2323]

Hello,

I have survey data that I am interested in visualizing, but have been running into some issues in terms of shaping and unpivoting the data, as well as visualizing. 

Goal: Create a dashboard where I can see the total amounts, as well as be able to cut the data by individual categories (i.e. see how many projects are climate focused) 

Challenges: 1) Unpivoting the data without duplicating the project dollar amounts. 2) Visualizing the correct values as individual categories "Research" not "Research; Advocacy". 3) Create dashboards that reflect 

I appreciate your help, as I have tried out a couple of different solutions and I am still running into issues. 

Dashboard example: 

Data: 

Project Name	Grant Year	Amount	Length	Approval Method	Active	Activity	Industry	Focus Area	Target Populations	Geography Served
Infrastructure Project	2023	500000	10	No	Yes	Research; Planning; Advocacy	Infrastructure; Climate; Green Tech	Economic Development; Coordination	General; Multiple racial and ethnic groups	California; Hawaii
Moving Forward Together	2021	300000	6	Rolling	Yes	Planning; Collaboration; Advocacy	Climate	Coordination; Power building	General; Multiple racial and ethnic groups	Oregon; Maine
Collaboration Together	2021	300000	9	Yes	No	Analysis	Green Tech	Power building; Coordination	Multiple racial and ethnic groups	Maine; Wisconsin; Florida
EV Project	2022	400000	14	Rolling	No	Analysis; Collaboration	Evs	Economic Development; Leadership	General; Multiple racial and ethnic groups	Florida; Texas; Hawaii

[Ashish_Mathur]

Hi,

Creating your visuals is not a problem.  Based on the table that you have shared, show the expected result in a simple Table format.  Once we get the correct Table, we can switch to any visual we want.

[amitchandak]

@KK2323 , Create dimensions with this approch

Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c
https://medium.com/@amitchandak/power-bi-search-text-parts-in-text-ad2f9783ffa2