stacked color chart with multi value

[Vanessa250919]

Hello all,

I need one chart stacked with multi value,  it's possible ? 

in my example i will need a comparison between the blue bar and another bar which adds the pink and the green, but i need to see in this bar the difference between the yellow and green? Do you have a solution ? thank you very much.

[v-cazheng-msft · Accepted solution]

Hi @Vanessa250919 

You may consider these two workarounds.

1 Use Line and clustered column chart

Create a Calculated column to re-catalog data

NewCatalog = IF('Table'[Catalog]="PAK REEL AVG"||'Table'[Catalog]="PAK REST AVG","PAK REEL AVG&PAK REST AVG",'Table'[Catalog])

Create a Measure to add values of pink and green

PAK REST AVG = SUMX(FILTER('Table','Table'[Catalog]="PAK REST AVG"),'Table'[Amt])

Then, create visual with them. Chart will look like this:

2 Use Clustered Stacked Bar Chart. This chart is provided by third-party and some features may need additional purchase. For more details, please refer Clustered Stacked Bar Chart.

Import Clustered Stacked Bar Chart from AppSource

Create visual with it. Visual should look like this.

For more details, you may refer the attached pbix file.

Best Regards,

Community Support Team _ Caiyun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If you still have problems on it or I misunderstand your needs, please feel free to let us know. Thanks a lot!

[Vanessa250919]

Hello, 

I'm sorry but I'm in holliday ! 

A try to test your solution and I have one error message :

[VahidDM]

Hi @Vanessa250919 

Can you post sample data as text and expected output?
Not enough information to go on;

please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
4. Relation between your tables

Appreciate your Kudos!!
LinkedIn:www.linkedin.com/in/vahid-dm/