Forum Discussion
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 ...
Anonymous,
Drag the following calculated column to Legend.
Column = RANKX ( FILTER ( Table1, Table1[Frequency] = EARLIER ( Table1[Frequency] ) ), Table1[Requirement Level], , DESC, DENSE )
Sorry for the confusion, here is a picture of what I am trying to achieve.
Is there a way to have it like this, I got these dots by creating an index of the data
This is my set up for the graph above, (without the blue lines of course) --->
Thank-you for the help.
- Collin
Anonymous,
Drag the following calculated column to Legend.
Column =
RANKX (
FILTER ( Table1, Table1[Frequency] = EARLIER ( Table1[Frequency] ) ),
Table1[Requirement Level],
,
DESC,
DENSE
)
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