Forum Discussion
graph trouble summing
Anonymous,
Drag the following calculated column to Legend.
Column = RANKX ( FILTER ( Table1, Table1[Frequency] = EARLIER ( Table1[Frequency] ) ), Table1[Requirement Level], , DESC, DENSE )
Hi!
Im sure I replied to this post already...Dunno what happend with it haha.
Anyway, it isnt clear what you want to achieve with that visual. the visual is correct. Is using the "Frequency" field as a Category, so that gives us 4 Frequencies {1, 15, 30 ,400}. Thats why you have only 4 labels, which are the sum of "Requirement Level"
If "Requirement Level" is a Categorical variable, and frequency is not (but it looks like it is too...), change "Requirement Level" to data type "Text" and use Frequency in the Y axis instead.
Plus, Im sure that's not the visual for that data...
Anyway, let me know how everything goes.
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