Forum Discussion

Gabrielfranco's avatar
Gabrielfranco
Frequent Visitor
7 years ago
Solved

Graph using Bar Chart and Line Chart

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

 

Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    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.

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    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.