Reply
Highlighted
Frequent Visitor
Posts: 7
Registered: ‎06-29-2017

Year over year Survey comparison

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:

 

Data page.png

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?

 

 

Frequent Visitor
Posts: 7
Registered: ‎06-29-2017

Re: Year over year Survey comparison

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

 

Community Support Team
Posts: 4,014
Registered: ‎07-09-2016

Re: Year over year Survey comparison

@chrismark176,

 

You may select Unpivot Columns in Query Editor.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor
Posts: 7
Registered: ‎06-29-2017

Re: Year over year Survey comparison

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.

 

 

Community Support Team
Posts: 4,014
Registered: ‎07-09-2016

Re: Year over year Survey comparison

@chrismark176,

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.