Using hierarchy for Date filters

[sn123]

Hi,

I am trying to use Date Heirarchy and when using, when I drill down and if data has more than a years details, numbers from the years are getting mixed given the total. eg., if Jan 2017 value is 15 and Jan 2018 value is 10 i am getting only 1 column with value 25 which is wrong.

I am using Matrix visual and filtered to get data of Q1 for both 2016 and 2017.

I am looking to get something like

	2016			2017
	January	February	March	January	February	March
ABC	10	12	13	22	12	53
DEF	1	2	3	4	5	6
GHI	3	23	23	6	5	3

  But I am getting 

	Janury	February	March
ABC	32	24	66
DEF	5	7	9
GHI	9	28	26

It seemed like basic requirement but I couldnt find where I am missing.

Any help is much appreciated.

Thanks

S

[Stachu · Accepted solution]

you should use 'fork' drilldown rather than 'double arrows' one

[v-yuta-msft · Accepted solution]

Hi sn123,

You should click "Expand all down one level in the hierarchy" as below: 

Regards,

Jimmy Tao

[sn123]

Thank you Jimmy Tao. 

[Stachu · Accepted solution]

you should use 'fork' drilldown rather than 'double arrows' one