Multiple Colors within 1 bar of a Line and Clustered Column Chart possible?

[DM_95]

Hi Guys,

Does someone has an idea if it's possible to have multiple colors within 1 bar of a Line and Clustered Column Chart with some kind of measure. Below example:

Test =  Gross Sales + Outstanding Sales Orders

I want to visualize Gross Sales in a different color and Outstanding Sales orders in a different color of bar 'Test'--> to show which part of Test is (Actual) Gross Sales and which part is Outstanding Sales Orders

Thank you!

[amitchandak]

@DM_95 , if you are using more than one measure or legend you can not use conditional formatting