Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

graph trouble summing

     I have a graph that looks like this currently                     .    This is the data for the chart above-------------    ID Frequency Requirement Level Values in chart 1 1 ...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Anonymous,

     

    Drag the following calculated column to Legend.

    Column =
RANKX (
    FILTER ( Table1, Table1[Frequency] = EARLIER ( Table1[Frequency] ) ),
    Table1[Requirement Level],
    ,
    DESC,
    DENSE
)
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
7 years ago

Anonymous,

 

Drag the following calculated column to Legend.

Column =
RANKX (
    FILTER ( Table1, Table1[Frequency] = EARLIER ( Table1[Frequency] ) ),
    Table1[Requirement Level],
    ,
    DESC,
    DENSE
)
Anonymous's avatar
Anonymous
Not applicable
7 years ago

That did it, thankyou very much.

If i may ask what exectly the column does as far as what is EARLIER, FILTER, RANKX, DESC, DENSE. 

Tried looking through it but doesnt make sense. 

Thanks again .

  -Collin