HELP report graphic filtering

[Anonymous]

Hello community. I have a Date table. And I have a couple of tables like this:

Date	posts	likes	shares
3/05/2018	20	100	5
18/05/2017	10	105	8
3/05/2018	25	110	9
28/04/2018	10	111	10
15/04/2017	15	115	15
22/02/2018	22	120	20
1/02/2017	23	100	8

I'm trying to make a bar graphic that can filter by months and then each bar represents a year. Like this (sorry for the  quality of graphic):

Pleas help. I've been trying but can only do a graphic with the months JAN trough DIC of 2016, then JAN through DIC of 2017 and so on. Really need to make look like that picutre.

Thanks in advance

[SteveCampbell · Accepted solution]

I think your drawing is lovely.

Do you have a YEAR and MONTH in your date table? If not make one with YEAR = Year([Date]) and MONTH = Month([Date])

Choose a "clustered column chart" and put MONTH in the axis, and YEAR in the legend, and whatever you want in the value.

[Anonymous]

Thank you! It did work. I have a followup question though. 

If I have a table like this:

How could I make it so that it appears 2016 march next to 2017 march next to 2018 march next to 2016 april next to 2017 april next to 2018 april.. and so on. Kinda like this (I did it with paint so I can show you :v)

Thanks in advance!

[SteveCampbell]

Is this "2016 March" etc a hierarchy or new column you created? If you click on a column, you can go to the "Modeling" Tab and use "Sort by Column". You may need to create a sort column or use a datekey - You will need one unique value for each value.

I am assuming you have a month and year column you have concatenated. If so, you can create a column:

Sort Column = 

[Month] + 
divide ( [Year], 10000)

Then click on your concatenated column, go to modeling, sort by column > "Sort Column"

[Anonymous]

Thanks for the quick response.

My "2016 March" etc is a hierarchy and is sorted as a Date Hierarchy

I have a column called "Date" with data like this: tuesday, 1 december of 2009 (in spanish though).

So i have created a column 

Sort Column = 

[Month] + 
divide ( [Year], 10000)

And have sorted my column "Date" > "Sort Column" but the clustered column chart hasn't changed. 

Please help

Thank you

[Anonymous]

Got it! I made a column that looked like this: dic 2009 so I used that new column in the axis instead of the Date Hierarchy. Then sorted it by month of the year and that did it.

Thanks again for all the help

[SteveCampbell]

In this case, the EASIEST way is probably to do this:

Create

Month = 
Month([Date])

Drag this into tooltips of your graph, then in the elipse (Three dots) in the top right of your graph, click and say "Sort By Month". You can click on the AZ symbol to reverse the order.