Stacked chart with multiple values

[MiaZhao]

Hi Everyone,

How can I draw a stacked chart with multiple values?

For instance, show budget as one column, and actual by each salse as one column.

[MiaZhao]

More details.

Budget

month	year	budget
1	2018	100
2	2018	100
3	2018	100
4	2018	100
5	2018	75

Actual

date	sales	amount
5/1/2018	A	5
5/2/2018	B	30
5/3/2018	C	4
5/4/2018	A	5
5/5/2018	B	11
5/6/2018	C	9

[v-juanli-msft · Accepted solution]

Hi @MiaZhao

Formula below will help

Table =
VAR Table1 =
    SUMMARIZE (
        Budget,
        "value", CALCULATE ( MAX ( Budget[budget] ), FILTER ( Budget, [month] = 5 ) ),
        "Legend", "Budget",
        "category", "Budget"
    )
VAR Table2 =
    SUMMARIZE ( Actual, Actual[amount], [sales], "category", "may closed sales" )
RETURN
    UNION ( Table1, Table2 )

Here is my Pbix.

Best Regards

Maggie

[MiaZhao]

Thank you very much. Maggie.