Forum Discussion

DNA's avatar
DNA
Frequent Visitor
9 years ago

Line Chart With Values As a %

  What I'm trying to do is a line chart that's basically the same as a 100% Stacked Column Chart, but displays in a line graph format   X Axis: Month Aggregates (Mar, April, May) Y Axis: Percenta...
Need Help
shkabuzar's avatar
shkabuzar
Frequent Visitor
8 years ago

Hi,

Please try this.

Measure =
DIVIDE (
    SUM ( Table1[Count] ),
    CALCULATE ( SUM ( Table1[Count] ), ALLSELECTED ( Table1[Category] ) )
)
Anonymous's avatar
Anonymous
Not applicable
7 years ago

shkabuzar thanks, your help is the solution. I can show my graphic i want.