Forum Discussion

cosminc's avatar
cosminc
Post Partisan
7 years ago

Hierarchy multiple

Hi

I want to obtain a graph whit this dynamic:

3 dimensions like: City, Shop, Salesman

and Year, Month from calendar

and the graph shoud be playable like this: each City or each Shop or each Salesman and data split by years or month or not splitted

i've created 2 hierarchys - City/Shop/Salesman and Year/Month and put both on axis in a Stacked column chart but doesn't work properly.

is it posible?

Thanks,

Cosmin

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    Hi cosminc ,

     

    You could create a [Year-Month] column by concatenating [Year] and [Month], add this combined column into chart legend.

     

    Regards,

    Yuliana Gu

    • cosminc's avatar
      cosminc
      Post Partisan

      Hi

      ok but if i want to display 2019 vs 2018 (both jan feb) will be displayed with split on their months

      thanks,

      Cosmin