Is there anyway to show mutiple measures on different years
i have the requiremnt like in below where i need to show the two mesaures on different years using line chart . Is there any possible way to achieve it?
here if you see above screenshot i have two measures and three fiscal years currently i have differentiated by years like year+month .since i was not able to different on categorical year on the top with the quateters .I was able to do with single measure but not with two measures . Is there any way to achieve this?
@Anonymous : Yes if you see at year level i was able to do . But when i drill to quarter and month level i need the split based on year with two measures . Something like below but i have currently only one measure . Hope yu got it?
with the above data i need to show the sales and purchase with drill down to year ,qurter and month . At the year level i can show the sum(sales),sum(purchase) . But when i drill to quarter and month i need the categorization with year
label : 2017,2018,2019 and y axis : measure values and x axis : q1,q2,q3,q4
But currently i was not able to develop this view . Is there any other way to better represent this view with two measures with drill down feature?