Forum Discussion
Graph using Bar Chart and Line Chart
- 7 years ago
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.
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.