Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Combining two visuals in single visual

Hi, I have two stacked column bar charts as the following, the left one is Actual and the right one is Target. I wanted to combine them in a single visual and show each actual column adjacent to its...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

MFelix v-chuncz-msft  and

Here I have shared a screenshot of the tables:

Actual:

 

and below is the Target:

So now you have all the info needed to show the power of your designed tool, MS. POWER  BI to let me believe my investment wasn't all in vein!

Please answer!

MFelix's avatar
MFelix
Super User
7 years ago

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's avatar
    Anonymous
    Not applicable
    7 years ago

    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!

  • MFelix's avatar
    MFelix
    Super User
    7 years ago

    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