Forum Discussion

MiaZhao's avatar
MiaZhao
Helper I
8 years ago
Solved

Stacked chart with multiple values

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.  
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    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

v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

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's avatar
MiaZhao
Helper I
8 years ago

Thank you very much. Maggie.