Forum Discussion

Masthan's avatar
Masthan
Frequent Visitor
2 years ago
Solved

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:  ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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