graph trouble summing

[Anonymous]

 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	70	point 1
1	15	106	?
1	30	106	?
1	15	96	?
1	30	96	?
1	30	106	?
1	400	96	point 4

I would like it to show all 7 points (not just 4)and not sum diffrent things. I have made the frequency and requirement columns set to not sum from the modeling tab. "values in chart "column is not part of graph.

Thanks for the help. 

- Collin

[NAOS]

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.

[Anonymous]

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

[v-chuncz-msft · Accepted solution]

@Anonymous,

Drag the following calculated column to Legend.

Column =
RANKX (
    FILTER ( Table1, Table1[Frequency] = EARLIER ( Table1[Frequency] ) ),
    Table1[Requirement Level],
    ,
    DESC,
    DENSE
)

[Anonymous]

@v-chuncz-msft

[Anonymous]

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