Stacked Chart help!

[lewdow]

Hi. I have a data set which is sales volume of particular products by account. Each product has a product name and a product class. 

I'd like to draw a stacked bar chart which would show the following logic:

[Filter applied in filter pane] = Class A, Account 1

Stacked chart to show:

1) the volume of all products within Class A for Account 1 (let's assume there are two products in Class A and so you would have 2 differently coloured bars stacked) AND

2) a third stack which would be grey in colour that effectively shows the volume of all other products (i.e. all products within class B, C, D) for Account 1

Is there an existing chart type that would enable this, or how would I go about structuring something that will enable me to draw this chart on a dynamic basis (so that different accounts can be selected at any point in time). 

Thanks

Lewis

[v-shex-msft · Accepted solution]

HI @lewdow ,

I'd like to suggest you to use line and stacked column chart to achieve your requirement.
Visual design:
Account to shared axis, Product Name to column series, Sales to column value, measure to line value.

Measure =
VAR sClass =
    VALUES ( Table[Product class] )
VAR sAccount =
    VALUES ( Table[Account] )
RETURN
    CALCULATE (
        SUM ( Table[Sales] ),
        FILTER (
            ALL ( Table ),
            NOT ( Table[Product class] IN sClass )
                && [Account] IN sAccount
        )
    )

Regards,
Xiaoxin Sheng