I have 6 measures. Three are monthly and three are YTD
As such, the monthly are on a different scale than the YTD.
I need to display in bars the current month, previous year month and current month target
In lines the YTD Sales, Previous YTD and YTD Budget.
When I followed the proposal with the A,B,C,D, by manupulating the data, I have the following problem:
The three bars of the current month overlap. The second image (Excel Chart) shows my final objective..
So instead on the orange and blue being stacked you would like them side by side? Does moving one of the dimensions to the columns shelf get you closer to the desired view?