Forum Discussion
Help with filters
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.
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
1 Reply
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