Hierarchy multiple

[cosminc]

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

[v-yulgu-msft]

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]

Hi

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

thanks,

Cosmin