Year by Year Comparison Graph

[Sheena]

Hello, I have a 2018 data set and 2019 data set that I added to the axis and values. Whichever data set I add second does not provide the actual values for each choice, but adds the total of all choices for each choice. For example, if 2019 data was added second to the values field, and there were 10 in North America, 12 in South America, 15 in Africa, and 8 in Europe, instead of showing the individual data for each country, it shows 45 for all countries. Does anyone know how to fix this?FieldsGraph

[parry2k]

@Sheena seems like your data is not read to visualize the way you want, share how your data table looks like and provide sample data to get you the solution.

[jdbuchanan71 · Accepted solution]

Hello @Sheena 

You will either want to combine the two tables into one using power query or create a locations table that will join the two data tables together.

You can create a locations table with something like this:

Locations =
DISTINCT (
    UNION (
        DISTINCT ( '2018Table'[Locations] ),
        DISTINCT ( '2019Table'[Locations] )
    )
)

Then join each of your data tables into it.

Then you use the locations from the new table in your chart.