Repeat Survey, Year to Year Comparison

[jminner]

I've seen a couple year to year comparisons, but none seem to match my format.  I appreciate any help that can be provided.

I have a survey that we provide to users each year.  Questions do not change, but number of respondents changes.  I have imported each Excel spreasdsheet as a unique dataset query.

2015 or 2016 Results can be graphed individually using count or % of Grand Total with no issues from their respective queries:

Primary Work Location - 2015

I apended the 2016 rows to the 2015 rows to create a third query, which allowed me to display year to year response counts in the same clustered column chart:

But graphing them together provides a calculation error when I try to use % of grand total (grand total incorrectly being the total number of rows for both years):

How do I get the left column to only calculate percent against 2015 rows, and the right column to calculate against 2016 rows?

Here's an example of Excel chart from last year:

In my queries, the first column is the Year of the results (currenty called "Start Date").

[v-ljerr-msft]

Hi @jminner,

According to your description, you may need to create a measure to calculate the  % of Grand Total in this scenario. Could you post your table structure with sample data in this case? It's better to share a sample pbix file. So that we can help with the measure.

Regards

[chrismark176]

@v-ljerr-msft,

I have the same question. There is a copy of my data set here:

https://community.powerbi.com/t5/Desktop/Year-over-year-Survey-comparison/m-p/203906#M89742

Hope you can help with answering this issue.