How to display same field from different tables in a column chart without aggregation

[mbm]

Hello Experts,

I'm trying to create a one column chart from two tables which has the same field but values are different. Please see below images for better understanding.

Sample Tables:

Expected Result is:

Say, Chart 1

But I'm getting either one of the below results instead of correctly splitting the values of Budget vs Expense which is wrong.

Say, Chart 2

Say, Chart 3

The amount values of Budget are getting aggregated if I select the amount field from the Expense table on X-axis of Column chart and vice versa.

How to adjust the fields in column chart to display the correct values as shown in chart 1.

Please help with your suggestions. Please let me know if you need any further inputs.

Thank you,

Bharath.

[Anonymous]

Hello @mbm ,
You're missing the relationship.

[Anonymous · Accepted solution]

Hi @mbm 
You can append this two tables in two one prior to this unpivot the columns like below

In your case just rename the column of Amount to Budget and another table amount to Expense

After unpivout you will get the result like below

You can make use of clustered column chart to get your desired result

Appreciate your Kudos, Press the thumbs up button!!👍

[mbm]

thanks @Anonymous . Appreciate your response and apologies for delay in my reply.

With your suggestion, I unpivoted the columns needed and it worked as expected.

[Anonymous]

@mbmWelcome 🙂
Appreciate your Kudos, Press the thumbs up button!!👍