Help with filters

[VitorR]

I'm trying to make a column chart where i can filter data by year, category and country.  Having some trouble with the year part. 

This is what i already achieved:

My data looks like this:

Country	Category	2010	2011	2012	2013
Brazil	Travel	VALUE	VALUE	VALUE	VALUE
Italy	Travel	VALUE	VALUE	VALUE	VALUE
France	Home Care	VALUE	VALUE	VALUE	VALUE

Any tips, books, videos would help a lot.

[mahoneypat · Accepted solution]

You should unpivot all your Year columns in the query editor.  This will give you a Year column that you can use on the axis, as the legend, in a slicer, etc.  In your case, in the query editor, Ctrl click to highlight the Country and Category columns, then right click and choose unpivot other columns.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat