Survey Visualization Power BI Report

Designed an interactive Power BI report that allows users to filter survey results by individual question. To enable this, I transformed the original wide survey dataset where each response existed in a single row with multiple survey question columns into an unpivoted structure via a duplicate table. Then, I created a relationship between the duplicate table that contains the unpivoted data with the original table to allow slicer interactivity across the entire Power Bi report regardless of which table is used in the visuals contained. The outcome enabled a dynamic slicer that allows users to select any question and update the survey results graph corresponding with the question as well as a method of filtering said results via Region and District (when drilled down).

My Role

I served as the sole designer and developer for this project, responsible for the full lifecycle from requirements analysis to deployment.

Table.Unpivot(
    #"Changed Type",
    {
        "Contact A Completed",
        "Pre-Start Condition Met",
        "Related Entity Present",
        "Contact B Completed",
        "Contact B Timely",
        "Contact C Completed",
        "Contact C Timely",
        "Contact D Completed",
        "Contact D Timely",
        "Contact A Attempts",
        "Pre-Start Review Logged",
        "Post-Start Review Logged",
        "Additional Notes Logged",
        "Notes",
        "Contact A Logged",
        "External Party Contacted",
        "External Information Relevant"
    },
    "Attribute",
    "Value"
)

M expression in Power Query Editor representing the columns I unpivoted (redacted)

1:N relationship between the original table and the duplicate unpivoted table.

One problem I encountered was the lack of descriptive value the column names had. I needed a way to convert the actual column names to the corresponding survey question for user readability. I used a DAX switch expression to convert the column name to the corresponding survey question.

Survey Question Title =
SWITCH(
    TRUE(),
    SELECTEDVALUE(DuplicateTable[Survey Question]) = "column name", "Full Question",
    "Select a question"
)

This expression (contained in a measure called ‘Survey Question Title’) was then used as the title property of the Survey Results column chart.

Results

Survey Response visual shows the selected survey question

Survey Response column chart changes dynamically when the survey question is changed.

The Survey Response column chart updates again when the “Surveys by Region/District” Pic chart is drilled down.