Forum Discussion
cosminc
7 years agoPost Partisan
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-msftMicrosoft 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
- cosmincPost 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