Forum Discussion

edlevud's avatar
edlevud
New Member
9 years ago
Solved

100% stacked chart and line

Hello,   I would like to create a 100% stacked bar graph that inlcludes a line as well, is this possible?    
Need Help
  • BetterCallFrank's avatar
    BetterCallFrank
    9 years ago

    Hi edlevud

    see my example above, it can be done just like you want, but the stacked 100% needs to be a measure with a calculation similar to what i mentioned above.

     

    post a screenshot of your data if you need help,

     

    HTH,

    Frank

BetterCallFrank's avatar
BetterCallFrank
Icon for Resolver IV rankResolver IV
9 years ago

edlevud you can use "stacked columns & lines" visual and make the calculation for the 100% in a measure.

for example

100pct = 
VAR Val1AllCats = CALCULATE( SUM( Table1[val1] ), ALL( Table1[cat] ) )
RETURN
DIVIDE( SUM( Table1[val1] ), Val1AllCats )

result

 

 

your example is not showing unfortunately - can you show us something more?