Graph using Bar Chart and Line Chart

[Gabrielfranco]

Hi everyone,

I'm trying to build a graph using three datas (States of country, production ($) and  years) witch should show the total amount of production for witch year and how much % of production each State represents over it. 

My ideia is build something like that below, but I have no clou how to do it on Power BI

[v-juanli-msft · Accepted solution]

Hi @Gabrielfranco

The legend would only affect the columns in a combo chart, so by default, there're two columns and one line. As a workaround, you can leave the legend field blank and create individual measures and put those measures to line values  if you'd like the epxected output.

Create measures

A% =
CALCULATE (
    SUM ( Sheet3[production] ),
    FILTER ( Sheet3, [state of country] = "A" )
)
    / CALCULATE ( SUM ( Sheet3[production] ), ALLEXCEPT ( Sheet3, Sheet3[years] ) )


B% =
CALCULATE (
    SUM ( Sheet3[production] ),
    FILTER ( Sheet3, [state of country] = "B" )
)
    / CALCULATE ( SUM ( Sheet3[production] ), ALLEXCEPT ( Sheet3, Sheet3[years] ) )

C% =
CALCULATE (
    SUM ( Sheet3[production] ),
    FILTER ( Sheet3, [state of country] = "C" )
)
    / CALCULATE ( SUM ( Sheet3[production] ), ALLEXCEPT ( Sheet3, Sheet3[years] ) )

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.