Forum Discussion
Combining two visuals in single visual
Hi Anonymous ,
Sorry for this questions but to help you in the best way we need to understand the result and data you provide, to what I can see from the print the csutom column on the Actuals matches the Team on the target correct?
Is this the X-Axis on your chart?
If yes what composes your categories withing each bar?
Regards,
MFelix
And what are the values you are counting/sum on your values?
Anonymous ,
You may select Unpivot Columns in Query Editor.
MFelix no none of them are my X-Axis!
actually the problem is I have to transpose the below matrix to be able to visualize it in the stacked column chart! which is my biggest problem...
What should I do? If there is anyother visual to furnish my need? Please don't repeat your previous solutions!
Anonymous ,
You may select Unpivot Columns in Query Editor.