not able/ don't know how to do economics graphics

[Anonymous]

i have an excel with diferent sheets. all with the same structure like this from year 2011 until 2016. photo bellow:

what i want is to make some graphics to see the grow or the decrease of the%cat/españa, España, Cat, etc(things in columns) for each class of the rows (empreses, establiments, etc) for all years.

So i want to compare each over the years to see if it went better or worst. Meaning for España, see for each category over the years how it grew. another graphic for Cat for each category how it grew,  etc.

i am an amateur in power bi but i think the worst is that i dont know a lot about economics and thus i dont exactly know how i can see all that in a graphic.

some help will be apreciated

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

You can use UNION() function in the DAX. Combine these tables to get a new table with columns you want regardless of whether the column name is the same.

Table 2 =
UNION (
    SELECTCOLUMNS (
        '2015',
        "name", '2015'[Name],
        "V1", '2015'[V1],
        "V2", '2015'[V2],
        "Year", "2015"
    ),
    SELECTCOLUMNS (
        '2016',
        "name", '2016'[Name],
        "V1", '2016'[V1],
        "V2", '2016'[V2],
        "Year", "2016"
    ),
    SELECTCOLUMNS (
        '2017',
        "name", '2017'[Name],
        "V1", '2017'[V1],
        "V2", '2017'[V2],
        "Year", "2017"
    )
)

Then you can use Area visual and slicer to get the result.

[PANDAmonium]

Assuming your column headers and row headers are the same across all tables, you need to add a year column and append all your tables together into one table. Here are the steps:

1. Add a "Year" column with values of that year. So for 2015, you would add a custom column of "= Table.AddColumn(#"Changed Type", "Year", each 2015)"
2. Repeat for all tables adjusting the year
3. Append Queries as New and add all tables

Then you can create your visualizations to show year over year change.