06-29-2017 08:27 AM
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?
06-29-2017 11:17 AM
I found an example of exactly what I want to do with the graphs:
06-30-2017 05:00 AM
You may select Unpivot Columns in Query Editor.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
06-30-2017 08:09 AM
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.
07-03-2017 03:40 AM