Forum Discussion
Merge Two Stacked Column Charts
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
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
4 Replies
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
You will need to make sure that the data belongs to the same category on X-Axis. Can you share sample pbix file?
I should not share the file here. So I was not able to do that.
can you please help me with possible examples.
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.
