Merge Two Stacked Column Charts

[Masthan]

Hi Team,

Is it posssible to merge two stacked column charts/Clustered column chart into single chart. Please find the below images.

Are there any custom visuals to achieve this.

Input:

Output:

Thanks- Masthanaiah

[v-yangliu-msft · Accepted solution]

Hi  @Masthan ,

I created some data:

If two Visual fields are the same data, you can create a measure to get the corresponding value.

Table1：

Table2：

Here are the steps you can follow

1. Create measure.

Measure =
SUMX(
    FILTER(ALL('Table'),
    'Table'[Group]=MAX('Table2'[Group])),[Value2])

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Kaviraj11]

I'll need to see the dataset to help further investiagte and solve the problem.

You can upload you file in Google Drive or other cloud platform and share the link here and I'll be able to download.

[Kaviraj11]

You will need to make sure that the data belongs to the same category on X-Axis. Can you share sample pbix file?

[Masthan]

I should not share the file here. So I was not able to do that.
can you please help me with possible examples.