Year over year Survey comparison

[chrismark176]

Good morning!

I have some survey data (An guest perception survey we do each year for a large event we host) we have been tracking and are now looking to do a YOY comparison to see where we are trending. The current data is set up like this:

There is also a column which identifies the year the survey was taken.

I want to be able to analyze each of these columns by year on an individual level, and comparing the percent total of each year to identify positive and negative trends Year over Year.

Each column is a question in the survey I want to analyze at all three levels: 2016, 2017, and YoY

Is there one DAX expression I can use to create graphs for each column? Or do I need an expression for each column I wish to analyze?

[v-chuncz-msft]

@chrismark176,

You may select Unpivot Columns in Query Editor.

[chrismark176]

Thank you @v-chuncz-msft

Could you be more specific on how that would work? I've unpovited columns for statement sat questions and then put them into stacked bar graphs, which worked beautifully, but I want to be able to work within a cluster bar graph here and it is not working to the level I wish.

[v-chuncz-msft]

@chrismark176,

For each level, you may use CALCULATE Function to add separate measures.

[chrismark176]

I found an example of exactly what I want to do with the graphs:

https://community.powerbi.com/t5/Desktop/Repeat-Survey-Year-to-Year-Comparison/m-p/102439/highlight/...