Stacked bar chart

[heeman_alpha]

I have stacked bar chart with 5 different values which I am getting from my SQL query.

Different stack showing different value in different colors. And that's fine.

Now I want to merge two different stack value and show as one ( as the same color), How can I achieve that without modifying my SQL query.

[Gysbert_Wassenaar]

Put a preceding load on top of your SQL query where you combine the two different values into one value. If you don't want to modify your script you can try using a calculated dimension. Something like =If(MyFieldHere = 'FirstValueThatShouldBeMerged' OR MyFieldHere = 'SecondValueThatShouldBeMerged', 'NewMergedValue', MyFieldHere)