Forum Discussion
Shaping Multiple-Select Survey Data for Visualization
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 |
2 Replies
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-ad2f9783ffa2Hi,
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.
