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!
Hi Anonymous ,
To be abble to add two different tables within a single visual (bar chart or other) you need to have columns that relate both of them otherwise or the visuals will give incorrect values, or no values at all, that's why is important to understand how both charts you present on your first post are setup.
Adding to this as v-chuncz-msft , refers you need to make the unpivot of data.
I apologize for not being abble to be more insightfull with the answers I giving to you however as you may realize if we don't know the exact way you have your data and the ways information relates and the expected output is difficult to give you the right answer at firts attempt.
If you believe that I'm makning to many questions or not understanding your problem exactly I also apologize and if you want I can reference some other users on the community that can try and help you.
Regards,
MFelix