Forum Discussion

sn123's avatar
sn123
Frequent Visitor
8 years ago
Solved

Using hierarchy for Date filters

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  
 JanuaryFebruary MarchJanuaryFebruaryMarch
ABC101213221253
DEF123456
GHI32323653

 

  But I am getting 

              

 JanuryFebruaryMarch
ABC322466
DEF579
GHI92826

 

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

Any help is much appreciated.

 

Thanks

S

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

  • Hi sn123,

     

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

     

    Regards,

    Jimmy Tao

3 Replies

  • Stachu's avatar
    Stachu
    Community Champion

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

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support

    Hi sn123,

     

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

     

    Regards,

    Jimmy Tao