cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
chrismark176 Frequent Visitor
Frequent Visitor

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?

 

 

4 REPLIES 4
chrismark176 Frequent Visitor
Frequent Visitor

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
Community Support Team

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.
chrismark176 Frequent Visitor
Frequent Visitor

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
Community Support Team

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.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 137 members 1,432 guests
Please welcome our newest community members: