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 choi...
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.

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.