Forum Discussion

Sheena's avatar
Sheena
New Member
6 years ago
Solved

Year by Year Comparison Graph

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

Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    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.

2 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    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's avatar
      jdbuchanan71
      Super User
      6 years ago

      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.