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
MFelix's avatar
MFelix
Super User
7 years ago
Hi @bestman,

Does the tables have any common field? Any connection that allows you to have the actuals related with the target?

You can create a dimension table with unique values that make the relationship.

Can you share a simple mockup of your data?

Regards,
MFelix
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?